APPS.BOM_COPY_BILL dependencies on BOM_COPY_ORGANIZATION_LIST

Line 6763: DELETE FROM bom_copy_organization_list

6759: SELECT copy_request_id
6760: FROM bom_copy_structure_request
6761: WHERE request_status = p_request_status);
6762:
6763: DELETE FROM bom_copy_organization_list
6764: WHERE copy_request_id IN (SELECT copy_request_id
6765: FROM bom_copy_structure_request
6766: WHERE request_status = p_request_status);
6767:

Line 6950: bom_copy_organization_list bcol

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

Line 6985: bom_copy_organization_list bcol,

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

Line 7029: bom_copy_organization_list bcol,

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

Line 7070: bom_copy_organization_list bcol

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

Line 7109: bom_copy_organization_list bcol

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

Line 7152: bom_copy_organization_list bcol

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