ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0B73869E053B46B63588994 SELECT distinct a.customer_trx_id, C.LINE_NUMBER, D.CONCATENATED_SEGMENTS, E.ITEM_TARIfF, f.organization_id, F.CUSTOMER_ID, F.RATE_PER_UNIT, F.EXCISE_DUTY_rATE, F.DUTY_AMOUNT, H.PAN_NO PAN_NO2, H.EXCISE_DUTY_REG_NO, H.EXCISE_DUTY_RANGE , H.EXCISE_DUTY_DIVISION , H.EXCISE_DUTY_COMM,H.ST_REG_NO ST_REG_NO2 ,H.CST_REG_NO CST_REG_NO2, r.party_name customer_name, SUBSTR(j.ADDRESS1,1,5), SUBSTR(j.ADDRESS2,1,5), SUBSTR(j.ADDRESS3,1,5), SUBSTR(j.ADDRESS4,1,5), C.QUANTITY_INVOICED, a.trx_number, a.trx_date, C.UOM_CODE, C.EXTENDED_AMOUNT, C.LINE_TYPE, C.CUSTOMER_TRX_LINE_ID, b.delivery_id FROM RA_CUSTOMER_TRX_ALL A, JAI_OM_WSH_LINES_ALL b, RA_CUSTOMER_TRX_LINES_ALL C, MTL_SYSTEM_ITEMS_KFV D, JAI_INV_ITM_SETUPS E, JAI_CMN_RG_23D_TRXS F, hz_cust_site_uses_all G, JAI_CMN_CUS_ADDRESSES H, HZ_LOCATIONS J, HZ_PARTY_SITES HZPS, HZ_CUST_ACCT_SITES_ALL HZCAS, hz_parties r, hz_cust_accounts hzca WHERE a.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID and a.created_from = 'RAXTRX' and b.delivery_id = to_number(a.interface_header_attribute3) and b.order_line_id = to_number(c.interface_line_attribute6) AND f.reference_LINE_ID = b.delivery_detail_id AND E.INVENTORY_ITEM_ID= B.INVENTORY_ITEM_ID AND E.ORGANIZATION_ID = B.ORGANIZATION_ID AND F.INVENTORY_ITEM_ID= B.INVENTORY_ITEM_ID AND F.ORGANIZATION_ID = B.ORGANIZATION_ID AND D.INVENTORY_ITEM_ID= B.INVENTORY_ITEM_ID AND D.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.BILL_TO_CUSTOMER_ID = nvl(:p_customer_id, A.BILL_TO_CUSTOMER_ID) AND A.BILL_TO_CUSTOMER_ID = F.CUSTOMER_ID AND hzca.cust_account_id = f.customer_id AND r.party_id = hzca.party_id and b.organization_id = nvl(:p_org_id, b.organization_id) and b.location_id = nvl(:p_loc_id, b.location_id) and a.customer_trx_id = nvl(:p_invoice_no,a.customer_trx_id) AND G.SITE_USE_ID= F.SHIP_TO_SITE_ID AND G.cust_acct_site_id = H.ADDRESS_ID AND H.ADDRESS_ID= hzcas.cust_acct_site_id AND hzcas.party_site_id = hzps.party_site_id AND hzps.location_id = j.location_id and f.organization_id=:organization_id1 ORDER BY 16 ASC,15 ASC,23 ASC,24 ASC,13 ASC,14 ASC,12 ASC,11 ASC,17 ASC,6 ASC,10 ASC,5 ASC,20 ASC,19 ASC,21 ASC,18 ASC,1 ASC Y JA JAINCINI_XML US JA India - Commercial Invoice - draft Application: Asia/Pacific Localizations Source: India - Commercial Invoice Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINCINI_XML DB package: JAINCINI ZHS JA 印度 - 商业发票报表- 不支持：已保留供将来使用 Application: 亚太地区本地化 Source: 印度 - 商业发票报表 (XML) - 不支持：已保留供将来使用 Short Name: JAINCINI_XML DB package: JAINCINI BI Publisher :organization_id1 :p_customer_id :p_invoice_no :p_loc_id :p_org_id 1 10 :p_org_id LOV Oracle JAI_INV_ORG Y select organization_id id, organization_name value, null description from org_organization_definitions order by value,description Y US Organization ZHS 组织 2 20 :p_loc_id LOV Oracle JA_IN_P_COMM_LOCATIONS Y select location_id id, description value, null description from hr_locations order by location_id US Location ZHS 地点 3 30 :p_customer_id LOV Oracle P_Comm_Customers Y select hzca.cust_account_id id, hzp.party_name value, null description from hz_parties hzp,hz_cust_accounts hzca where hzp.party_id=hzca.party_id order by value,description US Customer ZHS 客户 4 40 :p_order LOV Oracle P_Order Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1021375 order by ffvv.flex_value US Order/Invoice ZHS 订单/发票 5 50 :p_invoice_no LOV Oracle P_Comm_Trx_Number Y select customer_trx_id id, trx_number value, null description from ra_customer_trx_all where (customer_trx_id in (select customer_trx_id from jai_ar_trxs where organization_id=:$flex$.jai_inv_org)) order by customer_trx_id US Invoice ZHS 发票