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 6853: mtl_parameters mp,

6849: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
6850: IS
6851: SELECT mp.organization_code
6852: FROM mtl_system_items_b msib,
6853: mtl_parameters mp,
6854: bom_copy_organization_list bcol
6855: WHERE msib.inventory_item_id = cp_item_id
6856: AND msib.organization_id = mp.organization_id
6857: AND bcol.copy_request_id = cp_copy_request_id

Line 6888: FROM mtl_parameters mp,

6884:
6885: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
6886: IS
6887: SELECT mp.organization_code
6888: FROM mtl_parameters mp,
6889: bom_copy_organization_list bcol,
6890: bom_structures_b bsb,
6891: bom_copy_structure_request bcsr
6892: WHERE bsb.assembly_item_id = cp_item_id

Line 6932: FROM mtl_parameters mp,

6928:
6929: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
6930: IS
6931: SELECT mp.organization_code
6932: FROM mtl_parameters mp,
6933: bom_copy_organization_list bcol,
6934: bom_structures_b bsb,
6935: bom_copy_structure_request bcsr
6936: WHERE bsb.bill_sequence_id <> bsb.source_bill_sequence_id

Line 6973: FROM mtl_parameters mp,

6969:
6970: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
6971: IS
6972: SELECT mp.organization_code
6973: FROM mtl_parameters mp,
6974: bom_copy_organization_list bcol
6975: WHERE bcol.copy_request_id = cp_copy_request_id
6976: AND bcol.organization_id = mp.organization_id
6977: AND NOT EXISTS (

Line 7012: FROM mtl_parameters mp,

7008:
7009: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
7010: IS
7011: SELECT mp.organization_code
7012: FROM mtl_parameters mp,
7013: bom_copy_organization_list bcol
7014: WHERE bcol.copy_request_id = cp_copy_request_id
7015: AND bcol.organization_id = mp.organization_id
7016: AND bcol.common_structure = 'N'

Line 7055: FROM mtl_parameters mp,

7051:
7052: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
7053: IS
7054: SELECT mp.organization_code
7055: FROM mtl_parameters mp,
7056: bom_copy_organization_list bcol
7057: WHERE bcol.copy_request_id = cp_copy_request_id
7058: AND bcol.organization_id = mp.organization_id
7059: AND bcol.common_structure = 'Y'