eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_COPY_BILL dependencies on MTL_PARAMETERS

Line 6949: mtl_parameters mp,

6945: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
6946: IS
6947: SELECT mp.organization_code
6948: FROM mtl_system_items_b msib,
6949: mtl_parameters mp,
6950: bom_copy_organization_list bcol
6951: WHERE msib.inventory_item_id = cp_item_id
6952: AND msib.organization_id = mp.organization_id
6953: AND bcol.copy_request_id = cp_copy_request_id

Line 6984: FROM mtl_parameters mp,

6980:
6981: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
6982: IS
6983: SELECT mp.organization_code
6984: FROM mtl_parameters mp,
6985: bom_copy_organization_list bcol,
6986: bom_structures_b bsb,
6987: bom_copy_structure_request bcsr
6988: WHERE bsb.assembly_item_id = cp_item_id

Line 7028: FROM mtl_parameters mp,

7024:
7025: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
7026: IS
7027: SELECT mp.organization_code
7028: FROM mtl_parameters mp,
7029: bom_copy_organization_list bcol,
7030: bom_structures_b bsb,
7031: bom_copy_structure_request bcsr
7032: WHERE bsb.bill_sequence_id <> bsb.source_bill_sequence_id

Line 7069: FROM mtl_parameters mp,

7065:
7066: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
7067: IS
7068: SELECT mp.organization_code
7069: FROM mtl_parameters mp,
7070: bom_copy_organization_list bcol
7071: WHERE bcol.copy_request_id = cp_copy_request_id
7072: AND bcol.organization_id = mp.organization_id
7073: AND NOT EXISTS (

Line 7108: FROM mtl_parameters mp,

7104:
7105: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
7106: IS
7107: SELECT mp.organization_code
7108: FROM mtl_parameters mp,
7109: bom_copy_organization_list bcol
7110: WHERE bcol.copy_request_id = cp_copy_request_id
7111: AND bcol.organization_id = mp.organization_id
7112: AND bcol.common_structure = 'N'

Line 7151: FROM mtl_parameters mp,

7147:
7148: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
7149: IS
7150: SELECT mp.organization_code
7151: FROM mtl_parameters mp,
7152: bom_copy_organization_list bcol
7153: WHERE bcol.copy_request_id = cp_copy_request_id
7154: AND bcol.organization_id = mp.organization_id
7155: AND bcol.common_structure = 'Y'