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 BOM_COPY_STRUCTURE_REQUEST

Line 561: -- Request Id for this copy operation. Value from BOM_COPY_STRUCTURE_REQUEST_S

557: copy_all_rfds_flag IN VARCHAR2 DEFAULT 'N',
558: copy_all_subcomps_flag IN VARCHAR2 DEFAULT 'N',
559: -- copy_all_compops_flag IN VARCHAR2 DEFAULT 'N',
560: copy_attach_flag IN VARCHAR2 DEFAULT 'Y',
561: -- Request Id for this copy operation. Value from BOM_COPY_STRUCTURE_REQUEST_S
562: -- To populate the errors in MTL_INTERFACE_ERRORS with this transaction id
563: p_copy_request_id IN NUMBER,
564: -- Unit number for copy to item
565: eco_end_item_rev_id IN NUMBER DEFAULT NULL,

Line 6664: FROM bom_copy_structure_request

6660: BEGIN
6661: DELETE FROM bom_copy_structure_actions
6662: WHERE copy_request_id IN (
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

Line 6669: 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:
6672: DELETE FROM bom_copy_structure_request
6673: WHERE request_status = p_request_status;

Line 6672: DELETE FROM bom_copy_structure_request

6668: WHERE copy_request_id IN (SELECT copy_request_id
6669: FROM bom_copy_structure_request
6670: WHERE request_status = p_request_status);
6671:
6672: DELETE FROM bom_copy_structure_request
6673: WHERE request_status = p_request_status;
6674: END purge_processed_copy_requests;
6675:
6676: PROCEDURE purge_processed_request_errors (p_request_status IN VARCHAR2)

Line 6682: FROM bom_copy_structure_request bscr

6678: BEGIN
6679: DELETE FROM mtl_interface_errors mie
6680: WHERE EXISTS (
6681: SELECT 1
6682: FROM bom_copy_structure_request bscr
6683: WHERE bscr.copy_request_id = mie.transaction_id
6684: AND bscr.request_status = p_request_status
6685: AND mie.bo_identifier = 'BOM_COPY');
6686: END purge_processed_request_errors;

Line 6891: bom_copy_structure_request bcsr

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
6894: AND bsb.organization_id = bcol.organization_id
6895: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =

Line 6935: bom_copy_structure_request bcsr

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
6938: AND bcsr.copy_request_id = cp_copy_request_id
6939: AND bsb.organization_id = bcol.organization_id

Line 7019: FROM bom_copy_structure_request bcsr,

7015: AND bcol.organization_id = mp.organization_id
7016: AND bcol.common_structure = 'N'
7017: AND NOT EXISTS (
7018: SELECT 1
7019: FROM bom_copy_structure_request bcsr,
7020: bom_structures_b bsb
7021: WHERE bsb.assembly_item_id = cp_item_id
7022: AND bcsr.copy_request_id = bcol.copy_request_id
7023: AND bsb.organization_id = bcol.organization_id

Line 7062: FROM bom_copy_structure_request bcsr,

7058: AND bcol.organization_id = mp.organization_id
7059: AND bcol.common_structure = 'Y'
7060: AND NOT EXISTS (
7061: SELECT 1
7062: FROM bom_copy_structure_request bcsr,
7063: bom_structures_b bsb
7064: WHERE bcsr.copy_request_id = bcol.copy_request_id
7065: AND bsb.organization_id = bcol.organization_id
7066: AND bsb.assembly_item_id = cp_item_id

Line 7125: -- Request Id for this copy operation. Value from BOM_COPY_STRUCTURE_REQUEST_S

7121: eco_eff_date IN DATE,
7122: eco_unit_number IN VARCHAR2 DEFAULT NULL,
7123: unit_number IN VARCHAR2 DEFAULT NULL,
7124: from_item_id IN NUMBER,
7125: -- Request Id for this copy operation. Value from BOM_COPY_STRUCTURE_REQUEST_S
7126: -- To populate the errors in MTL_INTERFACE_ERRORS with this transaction id
7127: p_copy_request_id IN NUMBER,
7128: -- Unit number for copy to item
7129: eco_end_item_rev_id IN NUMBER DEFAULT NULL,