APPS.INV_MGD_MVT_PO_MDTR dependencies on HZ_CUST_ACCOUNTS

Line 778: --Bugfix 9676611: customer_number should come from HZ_CUST_ACCOUNTS

774: , abs(nvl(oola.unit_selling_price,0) * nvl(oola.shipped_quantity,0)) doc_line_ext
775: , oola.orig_sys_line_ref
776: , ooha.orig_sys_document_ref
777: , rac.party_name
778: --Bugfix 9676611: customer_number should come from HZ_CUST_ACCOUNTS
779: --, rac.party_number
780: , hzc.account_number
781: FROM
782: OE_ORDER_HEADERS_ALL ooha

Line 785: , HZ_CUST_ACCOUNTS hzc

781: FROM
782: OE_ORDER_HEADERS_ALL ooha
783: , OE_ORDER_LINES_ALL oola
784: , HZ_PARTIES rac
785: , HZ_CUST_ACCOUNTS hzc
786: , MTL_SYSTEM_ITEMS si
787: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
788: WHERE ooha.header_id = oola.header_id
789: AND oola.inventory_item_id = si.inventory_item_id

Line 1842: --Bugfix 9676611: customer_number should come from HZ_CUST_ACCOUNTS

1838: , oola.source_document_id req_hd_id
1839: , oola.source_document_line_id req_ln_id
1840: --, to_number(NULL) pick_slip_ref
1841: , rac.party_name cust_name
1842: --Bugfix 9676611: customer_number should come from HZ_CUST_ACCOUNTS
1843: --, rac.party_number cust_number
1844: , hzc.account_number cust_number
1845: , substrb(rac.province,1,30) area
1846: , wnd.name shipment_reference

Line 1855: , HZ_CUST_ACCOUNTS hzc

1851: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
1852: , OE_ORDER_HEADERS_ALL ooha
1853: , OE_ORDER_LINES_ALL oola
1854: , HZ_PARTIES rac
1855: , HZ_CUST_ACCOUNTS hzc
1856: WHERE wnd.delivery_id = wda.delivery_id
1857: AND wda.delivery_detail_id = wdd.delivery_detail_id
1858: AND wdd.source_line_id = oola.line_id
1859: AND ooha.header_id = oola.header_id