DBA Data[Home] [Help]

APPS.CST_MGD_LIFO_COST_PROCESSOR dependencies on MTL_SYSTEM_ITEMS_KFV

Line 951: , mtl_system_items_kfv kfv

947: , cst_pac_periods pp
948: , cst_pac_item_costs pic
949: , cst_pac_quantity_layers pql
950: , mtl_system_items msi
951: , mtl_system_items_kfv kfv
952: WHERE clt.legal_entity = p_legal_entity_id
953: AND pp.legal_entity = clt.legal_entity
954: AND cg.legal_entity = clt.legal_entity
955: AND cg.cost_group_id = p_cost_group_id

Line 1010: , mtl_system_items_kfv kfv

1006: , cst_pac_periods pp
1007: , cst_pac_item_costs pic
1008: , cst_pac_quantity_layers pql
1009: , mtl_system_items msi
1010: , mtl_system_items_kfv kfv
1011: WHERE clt.legal_entity = p_legal_entity_id
1012: AND pp.legal_entity = clt.legal_entity
1013: AND cg.legal_entity = clt.legal_entity
1014: AND cg.cost_group_id = p_cost_group_id

Line 1198: , mtl_system_items_kfv kfv

1194: , cst_pac_periods pp
1195: , cst_pac_item_costs pic
1196: , cst_pac_quantity_layers pql
1197: , mtl_system_items msi
1198: , mtl_system_items_kfv kfv
1199: WHERE clt.legal_entity = p_legal_entity_id
1200: AND pp.legal_entity = clt.legal_entity
1201: AND cg.legal_entity = clt.legal_entity
1202: AND cg.cost_group_id = p_cost_group_id

Line 1254: , mtl_system_items_kfv kfv

1250: , cst_pac_periods pp
1251: , cst_pac_item_costs pic
1252: , cst_pac_quantity_layers pql
1253: , mtl_system_items msi
1254: , mtl_system_items_kfv kfv
1255: WHERE clt.legal_entity = p_legal_entity_id
1256: AND pp.legal_entity = clt.legal_entity
1257: AND cg.legal_entity = clt.legal_entity
1258: AND cg.cost_group_id = p_cost_group_id

Line 1324: , mtl_system_items_kfv kfv

1320: , cst_pac_periods pp
1321: , cst_pac_item_costs pic
1322: , cst_pac_quantity_layers pql
1323: , mtl_system_items msi
1324: , mtl_system_items_kfv kfv
1325: WHERE clt.legal_entity = p_legal_entity_id
1326: AND pp.legal_entity = clt.legal_entity
1327: AND cg.legal_entity = clt.legal_entity
1328: AND cg.cost_group_id = p_cost_group_id

Line 1385: , mtl_system_items_kfv kfv

1381: , cst_pac_periods pp
1382: , cst_pac_item_costs pic
1383: , cst_pac_quantity_layers pql
1384: , mtl_system_items msi
1385: , mtl_system_items_kfv kfv
1386: WHERE clt.legal_entity = p_legal_entity_id
1387: AND pp.legal_entity = clt.legal_entity
1388: AND cg.legal_entity = clt.legal_entity
1389: AND cg.cost_group_id = p_cost_group_id

Line 1510: FROM mtl_system_items_kfv

1506: SELECT
1507: inventory_item_id
1508: INTO
1509: l_item_from
1510: FROM mtl_system_items_kfv
1511: WHERE concatenated_segments = p_item_code_from
1512: AND organization_id = l_master_org;
1513: END IF;
1514:

Line 1521: FROM mtl_system_items_kfv

1517: SELECT
1518: inventory_item_id
1519: INTO
1520: l_item_to
1521: FROM mtl_system_items_kfv
1522: WHERE concatenated_segments = p_item_code_to
1523: AND organization_id = l_master_org;
1524: END IF;
1525:

Line 2508: ,MTL_SYSTEM_ITEMS_KFV msi

2504: msi.inventory_item_id
2505: FROM
2506: CST_PAC_PERIODS pp
2507: ,CST_PAC_ITEM_COSTS pic
2508: ,MTL_SYSTEM_ITEMS_KFV msi
2509: ,MTL_ITEM_CATEGORIES mic
2510: ,MTL_CATEGORIES_KFV mc
2511: WHERE pp.legal_entity = c_legal_entity_id
2512: AND pic.cost_group_id = c_cost_group_id