APPS.PO_REQIMP_PKG dependencies on MTL_SYSTEM_ITEMS

Line 631: FROM mtl_system_items

627:
628: IF l_document_line_num is null or l_document_line_num = 0 THEN
629: SELECT list_price_per_unit
630: INTO l_unit_price
631: FROM mtl_system_items
632: WHERE inventory_item_id = x_item_id
633: AND organization_id = x_organization_id ;
634:
635: UPDATE po_requisitions_interface

Line 729: FROM mtl_system_items

725: BEGIN
726:
727: SELECT nvl(unit_of_issue,primary_unit_of_measure)
728: INTO l_unit_of_issue
729: FROM mtl_system_items
730: WHERE inventory_item_id = x_item_id
731: AND organization_id = x_source_organization_id ;
732:
733:

Line 887: mtl_system_items.inventory_item_id%TYPE,

883: org_organization_definitions.organization_id%TYPE,
884: x_subinv IN
885: mtl_secondary_inventories.secondary_inventory_name%TYPE,
886: x_item_id IN
887: mtl_system_items.inventory_item_id%TYPE,
888: x_subinv_ccid IN OUT NOCOPY
889: mtl_secondary_inventories.expense_account%TYPE,
890: x_item_ccid IN OUT NOCOPY
891: mtl_system_items.expense_account%TYPE)

Line 891: mtl_system_items.expense_account%TYPE)

887: mtl_system_items.inventory_item_id%TYPE,
888: x_subinv_ccid IN OUT NOCOPY
889: mtl_secondary_inventories.expense_account%TYPE,
890: x_item_ccid IN OUT NOCOPY
891: mtl_system_items.expense_account%TYPE)
892: IS
893: BEGIN
894:
895: l_error_msg := 'AUTOGL ERROR - Could not retrieve subinventory expense_account';

Line 912: FROM mtl_system_items

908: l_error_msg := 'AUTOGL ERROR - Could not retrieve item expense_account';
909:
910: SELECT nvl(expense_account, -1)
911: INTO x_item_ccid
912: FROM mtl_system_items
913: WHERE organization_id = x_org_id
914: AND inventory_item_id = x_item_id ;
915:
916: IF x_item_ccid = -1 THEN

Line 1159: mtl_system_items.expense_account%TYPE)

1155: JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE,
1156: x_subinv_ccid IN
1157: mtl_secondary_inventories.expense_account%TYPE,
1158: x_item_ccid IN
1159: mtl_system_items.expense_account%TYPE)
1160: RETURN gl_code_combinations.segment1%TYPE IS
1161:
1162: l_value gl_code_combinations.segment1%TYPE;
1163:

Line 1172: ELSIF x_table_name = 'MTL_SYSTEM_ITEMS' THEN

1168: l_value := JA_AU_get_value(x_rowid,
1169: x_transaction_id,
1170: x_subinv_ccid,
1171: x_segment);
1172: ELSIF x_table_name = 'MTL_SYSTEM_ITEMS' THEN
1173: l_value := JA_AU_get_value(x_rowid,
1174: x_transaction_id,
1175: x_item_ccid,
1176: x_segment);

Line 1290: l_item_ccid mtl_system_items.expense_account%TYPE;

1286:
1287: l_chart_of_accts_id org_organization_definitions.organization_id%TYPE;
1288: l_set_of_books_id org_organization_definitions.set_of_books_id%TYPE;
1289: l_subinv_ccid mtl_secondary_inventories.expense_account%TYPE;
1290: l_item_ccid mtl_system_items.expense_account%TYPE;
1291: l_table_name JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE;
1292: l_constant JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE;
1293: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;
1294: l_segvalues fnd_flex_ext.segmentarray;