APPS.PO_REQIMP_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 885: mtl_secondary_inventories.secondary_inventory_name%TYPE,

881: po_requisitions_interface.transaction_id%TYPE,
882: x_org_id IN
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,

Line 889: mtl_secondary_inventories.expense_account%TYPE,

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)
892: IS
893: BEGIN

Line 899: FROM mtl_secondary_inventories

895: l_error_msg := 'AUTOGL ERROR - Could not retrieve subinventory expense_account';
896:
897: SELECT nvl(expense_account, -1)
898: INTO x_subinv_ccid
899: FROM mtl_secondary_inventories
900: WHERE organization_id = x_org_id
901: AND secondary_inventory_name = x_subinv ;
902:
903: IF x_subinv_ccid = -1 THEN

Line 1157: mtl_secondary_inventories.expense_account%TYPE,

1153: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,
1154: x_segment IN
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:

Line 1167: IF x_table_name = 'MTL_SECONDARY_INVENTORIES' THEN

1163:
1164: BEGIN
1165:
1166: IF SUBSTR(x_constant,1,2) = '!~' THEN /* Not a constant */
1167: IF x_table_name = 'MTL_SECONDARY_INVENTORIES' THEN
1168: l_value := JA_AU_get_value(x_rowid,
1169: x_transaction_id,
1170: x_subinv_ccid,
1171: x_segment);

Line 1289: l_subinv_ccid mtl_secondary_inventories.expense_account%TYPE;

1285: IS
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;