APPS.BOM_COPY_BILL dependencies on BOM_COPY_ORGANIZATION_LIST

Line 6667: DELETE FROM bom_copy_organization_list

6663: SELECT copy_request_id
6664: FROM bom_copy_structure_request
6665: WHERE request_status = p_request_status);
6666:
6667: DELETE FROM bom_copy_organization_list
6668: WHERE copy_request_id IN (SELECT copy_request_id
6669: FROM bom_copy_structure_request
6670: WHERE request_status = p_request_status);
6671:

Line 6854: bom_copy_organization_list bcol

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
6858: AND bcol.organization_id = mp.organization_id;

Line 6889: bom_copy_organization_list bcol,

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
6893: AND bcsr.copy_request_id = cp_copy_request_id

Line 6933: bom_copy_organization_list bcol,

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
6937: AND bsb.assembly_item_id = cp_item_id

Line 6974: bom_copy_organization_list bcol

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 (
6978: SELECT 1

Line 7013: bom_copy_organization_list bcol

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'
7017: AND NOT EXISTS (

Line 7056: bom_copy_organization_list bcol

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'
7060: AND NOT EXISTS (