APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on MTL_SYSTEM_ITEMS

Line 1442: , mtl_system_items msi

1438: ,poll.ship_to_location_id location_id
1439: from po_headers_all poh
1440: , po_lines_all pol
1441: , po_line_locations_all poll /*6841116*/
1442: , mtl_system_items msi
1443: , po_vendors pov
1444: , hr_locations hl /* Added by vkantamn for Bug#6083978 */
1445: -- , financials_system_parameters fsp /* Commented by vkantamn for Bug#6083978 */
1446: where

Line 1482: , mtl_system_items msi

1478: from rcv_transactions rta
1479: , rcv_shipment_headers rsh
1480: , rcv_shipment_lines rsl
1481: , po_lines_all pla
1482: , mtl_system_items msi
1483: , po_vendors pov
1484: , hr_locations_all hl
1485: where
1486: rta.transaction_id = cp_transaction_id

Line 1519: ,mtl_system_items msi

1515: oe_order_headers_all oeh
1516: ,oe_order_lines_all oel
1517: ,hz_parties hzp
1518: ,hz_cust_accounts hzca
1519: ,mtl_system_items msi
1520: where (p_document_id is null or p_document_id = '' or oeh.header_id = p_document_id)
1521: and oel.header_id = oeh.header_id
1522: and oel.line_id = p_document_line_id
1523: and oel.inventory_item_id = msi.inventory_item_id

Line 1551: ,mtl_system_items msi

1547: ,ra_customer_trx_lines_all rctl
1548: ,jai_ar_trxs jrct
1549: ,hz_parties hzp
1550: ,hz_cust_accounts hzca
1551: ,mtl_system_items msi
1552: where rct.customer_trx_id = p_document_id
1553: and jrct.customer_trx_id = rct.customer_trx_id
1554: and rctl.customer_trx_id = rct.customer_trx_id
1555: and rctl.customer_trx_line_id = p_document_line_id

Line 2075: FROM mtl_system_items msl

2071: AND jrec.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS');
2072: /* Bug 13430127 */
2073: CURSOR c_get_line_item(p_organization_id number,p_inventory_item_id number) IS
2074: select msl.segment1
2075: FROM mtl_system_items msl
2076: WHERE msl.inventory_item_id = p_inventory_item_id
2077: and msl.organization_id = p_organization_id;
2078: /* end -bug 13430127 */
2079: CURSOR c_get_dist_details IS