DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on MTL_SYSTEM_ITEMS

Line 786: , mtl_system_items msi

782: ,poll.ship_to_location_id location_id
783: from po_headers_all poh
784: , po_lines_all pol
785: , po_line_locations_all poll /*6843479*/
786: , mtl_system_items msi
787: , po_vendors pov
788: , hr_locations hl /* Added by vkantamn for Bug#6083978 */
789: -- , financials_system_parameters fsp /* Commented by vkantamn for Bug#6083978 */
790: where

Line 827: ,mtl_system_items msi

823: oe_order_headers_all oeh
824: ,oe_order_lines_all oel
825: ,hz_parties hzp
826: ,hz_cust_accounts hzca
827: ,mtl_system_items msi
828: where (p_document_id is null or p_document_id = '' or oeh.header_id = p_document_id)
829: and oel.header_id = oeh.header_id
830: and oel.line_id = p_document_line_id
831: and oel.inventory_item_id = msi.inventory_item_id

Line 891: ,mtl_system_items msi

887: ,ra_customer_trx_lines_all rctl
888: ,jai_ar_trxs jrct
889: ,hz_parties hzp
890: ,hz_cust_accounts hzca
891: ,mtl_system_items msi
892: where rct.customer_trx_id = p_document_id
893: and jrct.customer_trx_id = rct.customer_trx_id
894: and rctl.customer_trx_id = rct.customer_trx_id
895: and rctl.customer_trx_line_id = p_document_line_id