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 6760: FROM bom_copy_structure_request

6756: BEGIN
6757: DELETE FROM bom_copy_structure_actions
6758: WHERE copy_request_id IN (
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

Line 6765: 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:
6768: DELETE FROM bom_copy_structure_request
6769: WHERE request_status = p_request_status;

Line 6768: DELETE FROM bom_copy_structure_request

6764: WHERE copy_request_id IN (SELECT copy_request_id
6765: FROM bom_copy_structure_request
6766: WHERE request_status = p_request_status);
6767:
6768: DELETE FROM bom_copy_structure_request
6769: WHERE request_status = p_request_status;
6770: END purge_processed_copy_requests;
6771:
6772: PROCEDURE purge_processed_request_errors (p_request_status IN VARCHAR2)

Line 6778: FROM bom_copy_structure_request bscr

6774: BEGIN
6775: DELETE FROM mtl_interface_errors mie
6776: WHERE EXISTS (
6777: SELECT 1
6778: FROM bom_copy_structure_request bscr
6779: WHERE bscr.copy_request_id = mie.transaction_id
6780: AND bscr.request_status = p_request_status
6781: AND mie.bo_identifier = 'BOM_COPY');
6782: END purge_processed_request_errors;

Line 6987: bom_copy_structure_request bcsr

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

Line 7031: bom_copy_structure_request bcsr

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

Line 7115: FROM bom_copy_structure_request bcsr,

7111: AND bcol.organization_id = mp.organization_id
7112: AND bcol.common_structure = 'N'
7113: AND NOT EXISTS (
7114: SELECT 1
7115: FROM bom_copy_structure_request bcsr,
7116: bom_structures_b bsb
7117: WHERE bsb.assembly_item_id = cp_item_id
7118: AND bcsr.copy_request_id = bcol.copy_request_id
7119: AND bsb.organization_id = bcol.organization_id

Line 7158: FROM bom_copy_structure_request bcsr,

7154: AND bcol.organization_id = mp.organization_id
7155: AND bcol.common_structure = 'Y'
7156: AND NOT EXISTS (
7157: SELECT 1
7158: FROM bom_copy_structure_request bcsr,
7159: bom_structures_b bsb
7160: WHERE bcsr.copy_request_id = bcol.copy_request_id
7161: AND bsb.organization_id = bcol.organization_id
7162: AND bsb.assembly_item_id = cp_item_id

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

7217: eco_eff_date IN DATE,
7218: eco_unit_number IN VARCHAR2 DEFAULT NULL,
7219: unit_number IN VARCHAR2 DEFAULT NULL,
7220: from_item_id IN NUMBER,
7221: -- Request Id for this copy operation. Value from BOM_COPY_STRUCTURE_REQUEST_S
7222: -- To populate the errors in MTL_INTERFACE_ERRORS with this transaction id
7223: p_copy_request_id IN NUMBER,
7224: -- Unit number for copy to item
7225: eco_end_item_rev_id IN NUMBER DEFAULT NULL,