DBA Data[Home] [Help]

APPS.CSP_PART_SEARCH_PVT dependencies on MTL_PARAMETERS

Line 1289: from mtl_parameters

1285: l_insert_rec_c number;
1286:
1287: cursor c_get_master_org is
1288: select master_organization_id
1289: from mtl_parameters
1290: where organization_id = l_organization_id;
1291:
1292: cursor c_get_sup_items (v_inventory_item_id number, v_organization_id number, v_rel_type number) is
1293: SELECT related_item_id

Line 1429: mtl_parameters mp,

1425: mriv.related_item_id,
1426: crpt.quantity,
1427: 'SUBSTITUTE'
1428: from mtl_related_items_view mriv,
1429: mtl_parameters mp,
1430: csp_required_parts_temp crpt
1431: where mp.organization_id = l_organization_id
1432: and mriv.organization_id = mp.master_organization_id
1433: and mriv.inventory_item_id = crpt.inventory_item_id