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_ACTIONS

Line 1733: FROM bom_copy_structure_actions bcsa

1729: AND bev.bill_sequence_id = from_sequence_id
1730: AND bev.parent_sort_order = p_parent_sort_order
1731: AND NOT EXISTS (
1732: SELECT 1
1733: FROM bom_copy_structure_actions bcsa
1734: WHERE bcsa.component_sequence_id =
1735: bic.component_sequence_id
1736: AND bcsa.copy_request_id = p_copy_request_id
1737: AND bcsa.organization_id = to_org_id

Line 2133: FROM bom_copy_structure_actions bcsa

2129: AND bev.bill_sequence_id = from_sequence_id
2130: AND bev.parent_sort_order = p_parent_sort_order
2131: AND NOT EXISTS (
2132: SELECT 1
2133: FROM bom_copy_structure_actions bcsa
2134: WHERE bcsa.component_sequence_id =
2135: bic.component_sequence_id
2136: AND bcsa.copy_request_id = p_copy_request_id
2137: AND bcsa.organization_id = to_org_id

Line 2610: FROM bom_copy_structure_actions bcsa

2606: AND bev.bill_sequence_id = from_sequence_id
2607: AND bev.parent_sort_order = p_parent_sort_order
2608: AND NOT EXISTS (
2609: SELECT 1
2610: FROM bom_copy_structure_actions bcsa
2611: WHERE bcsa.component_sequence_id =
2612: bic.component_sequence_id
2613: AND bcsa.copy_request_id = p_copy_request_id
2614: AND bcsa.organization_id = to_org_id

Line 3051: FROM bom_copy_structure_actions bcsa

3047: AND bev.bill_sequence_id = from_sequence_id
3048: AND bev.parent_sort_order = p_parent_sort_order
3049: AND NOT EXISTS (
3050: SELECT 1
3051: FROM bom_copy_structure_actions bcsa
3052: WHERE bcsa.component_sequence_id =
3053: bic.component_sequence_id
3054: AND bcsa.copy_request_id = p_copy_request_id
3055: AND bcsa.organization_id = to_org_id

Line 3502: FROM bom_copy_structure_actions bcsa

3498: AND bev.bill_sequence_id = from_sequence_id
3499: AND bev.parent_sort_order = p_parent_sort_order
3500: AND NOT EXISTS (
3501: SELECT 1
3502: FROM bom_copy_structure_actions bcsa
3503: WHERE bcsa.component_sequence_id =
3504: bic.component_sequence_id
3505: AND bcsa.copy_request_id = p_copy_request_id
3506: AND bcsa.organization_id = to_org_id

Line 3790: FROM bom_copy_structure_actions bcsa

3786: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
3787: )
3788: AND NOT EXISTS (
3789: SELECT 1
3790: FROM bom_copy_structure_actions bcsa
3791: WHERE bcsa.component_sequence_id =
3792: bcb.component_sequence_id
3793: AND bcsa.copy_request_id = p_copy_request_id
3794: AND bcsa.organization_id = to_org_id

Line 3887: FROM bom_copy_structure_actions bcsa

3883: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
3884: )
3885: AND NOT EXISTS (
3886: SELECT 1
3887: FROM bom_copy_structure_actions bcsa
3888: WHERE bcsa.component_sequence_id =
3889: bcb.component_sequence_id
3890: AND bcsa.copy_request_id = p_copy_request_id
3891: AND bcsa.organization_id = to_org_id

Line 4025: FROM bom_copy_structure_actions bcsa

4021: bom_exploder_pub.get_ego_user
4022: )
4023: AND NOT EXISTS (
4024: SELECT 1
4025: FROM bom_copy_structure_actions bcsa
4026: WHERE bcsa.component_sequence_id =
4027: bcb.component_sequence_id
4028: AND bcsa.copy_request_id = p_copy_request_id
4029: AND bcsa.organization_id = to_org_id

Line 4110: FROM bom_copy_structure_actions bcsa

4106: bom_exploder_pub.get_ego_user
4107: )
4108: AND NOT EXISTS (
4109: SELECT 1
4110: FROM bom_copy_structure_actions bcsa
4111: WHERE bcsa.component_sequence_id =
4112: bcb.component_sequence_id
4113: AND bcsa.copy_request_id = p_copy_request_id
4114: AND bcsa.organization_id = to_org_id

Line 4256: FROM bom_copy_structure_actions bcsa

4252: bom_exploder_pub.get_ego_user
4253: )
4254: AND NOT EXISTS (
4255: SELECT 1
4256: FROM bom_copy_structure_actions bcsa
4257: WHERE bcsa.component_sequence_id =
4258: bcb.component_sequence_id
4259: AND bcsa.copy_request_id = p_copy_request_id
4260: AND bcsa.organization_id = to_org_id

Line 4336: FROM bom_copy_structure_actions bcsa

4332: bom_exploder_pub.get_ego_user
4333: )
4334: AND NOT EXISTS (
4335: SELECT 1
4336: FROM bom_copy_structure_actions bcsa
4337: WHERE bcsa.component_sequence_id =
4338: bcb.component_sequence_id
4339: AND bcsa.copy_request_id = p_copy_request_id
4340: AND bcsa.organization_id = to_org_id

Line 4573: FROM bom_copy_structure_actions bcsa

4569: bom_exploder_pub.get_ego_user
4570: )
4571: AND NOT EXISTS (
4572: SELECT 1
4573: FROM bom_copy_structure_actions bcsa
4574: WHERE bcsa.component_sequence_id =
4575: bcb.component_sequence_id
4576: AND bcsa.copy_request_id = p_copy_request_id
4577: AND bcsa.organization_id = to_org_id

Line 6480: FROM bom_copy_structure_actions bcsa

6476: AND msib.organization_id = c_org_id)
6477: AND ( NOT EXISTS (
6478: -- Direct Component Action is exclude
6479: SELECT 1
6480: FROM bom_copy_structure_actions bcsa
6481: WHERE bcsa.copy_request_id = p_copy_request_id
6482: AND bcsa.organization_id = p_to_org_id
6483: AND bcsa.component_sequence_id = bev.component_sequence_id
6484: AND bcsa.component_exception_action = 1

Line 6489: FROM bom_copy_structure_actions bcsa, bom_copy_explosions_v bcev

6485: )
6486: OR NOT EXISTS (
6487: -- Structure Action is exclude
6488: SELECT 1
6489: FROM bom_copy_structure_actions bcsa, bom_copy_explosions_v bcev
6490: WHERE bcsa.copy_request_id = p_copy_request_id
6491: AND bcsa.organization_id = p_to_org_id
6492: AND bcsa.structure_exception_action = 1
6493: AND bcsa.component_sequence_id = bcev.component_sequence_id

Line 6661: DELETE FROM bom_copy_structure_actions

6657:
6658: PROCEDURE purge_processed_copy_requests (p_request_status IN VARCHAR2)
6659: IS
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);

Line 7927: FROM bom_copy_structure_actions bcsa

7923: AND bev.bill_sequence_id = from_sequence_id
7924: AND bev.parent_sort_order = p_parent_sort_order
7925: AND NOT EXISTS (
7926: SELECT 1
7927: FROM bom_copy_structure_actions bcsa
7928: WHERE bcsa.component_sequence_id =
7929: bic.component_sequence_id
7930: AND bcsa.copy_request_id = p_copy_request_id
7931: AND bcsa.organization_id = to_org_id

Line 8295: FROM bom_copy_structure_actions bcsa

8291: AND bev.bill_sequence_id = from_sequence_id
8292: AND bev.parent_sort_order = p_parent_sort_order
8293: AND NOT EXISTS (
8294: SELECT 1
8295: FROM bom_copy_structure_actions bcsa
8296: WHERE bcsa.component_sequence_id =
8297: bic.component_sequence_id
8298: AND bcsa.copy_request_id = p_copy_request_id
8299: AND bcsa.organization_id = to_org_id

Line 8696: FROM bom_copy_structure_actions bcsa

8692: AND bev.bill_sequence_id = from_sequence_id
8693: AND bev.parent_sort_order = p_parent_sort_order
8694: AND NOT EXISTS (
8695: SELECT 1
8696: FROM bom_copy_structure_actions bcsa
8697: WHERE bcsa.component_sequence_id =
8698: bic.component_sequence_id
8699: AND bcsa.copy_request_id = p_copy_request_id
8700: AND bcsa.organization_id = to_org_id

Line 9094: FROM bom_copy_structure_actions bcsa

9090: AND bev.bill_sequence_id = from_sequence_id
9091: AND bev.parent_sort_order = p_parent_sort_order
9092: AND NOT EXISTS (
9093: SELECT 1
9094: FROM bom_copy_structure_actions bcsa
9095: WHERE bcsa.component_sequence_id =
9096: bic.component_sequence_id
9097: AND bcsa.copy_request_id = p_copy_request_id
9098: AND bcsa.organization_id = to_org_id

Line 9493: FROM bom_copy_structure_actions bcsa

9489: AND bev.bill_sequence_id = from_sequence_id
9490: AND bev.parent_sort_order = p_parent_sort_order
9491: AND NOT EXISTS (
9492: SELECT 1
9493: FROM bom_copy_structure_actions bcsa
9494: WHERE bcsa.component_sequence_id =
9495: bic.component_sequence_id
9496: AND bcsa.copy_request_id = p_copy_request_id
9497: AND bcsa.organization_id = to_org_id

Line 9672: FROM bom_copy_structure_actions bcsa

9668: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
9669: )
9670: AND NOT EXISTS (
9671: SELECT 1
9672: FROM bom_copy_structure_actions bcsa
9673: WHERE bcsa.component_sequence_id =
9674: bcb.component_sequence_id
9675: AND bcsa.copy_request_id = p_copy_request_id
9676: AND bcsa.organization_id = to_org_id

Line 9801: FROM bom_copy_structure_actions bcsa

9797: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
9798: )
9799: AND NOT EXISTS (
9800: SELECT 1
9801: FROM bom_copy_structure_actions bcsa
9802: WHERE bcsa.component_sequence_id =
9803: bcb.component_sequence_id
9804: AND bcsa.copy_request_id = p_copy_request_id
9805: AND bcsa.organization_id = to_org_id

Line 9970: FROM bom_copy_structure_actions bcsa

9966: bom_exploder_pub.get_ego_user
9967: )
9968: AND NOT EXISTS (
9969: SELECT 1
9970: FROM bom_copy_structure_actions bcsa
9971: WHERE bcsa.component_sequence_id =
9972: bcb.component_sequence_id
9973: AND bcsa.copy_request_id = p_copy_request_id
9974: AND bcsa.organization_id = to_org_id

Line 10068: FROM bom_copy_structure_actions bcsa

10064: bom_exploder_pub.get_ego_user
10065: )
10066: AND NOT EXISTS (
10067: SELECT 1
10068: FROM bom_copy_structure_actions bcsa
10069: WHERE bcsa.component_sequence_id =
10070: bcb.component_sequence_id
10071: AND bcsa.copy_request_id = p_copy_request_id
10072: AND bcsa.organization_id = to_org_id

Line 10170: FROM bom_copy_structure_actions bcsa

10166: bom_exploder_pub.get_ego_user
10167: )
10168: AND NOT EXISTS (
10169: SELECT 1
10170: FROM bom_copy_structure_actions bcsa
10171: WHERE bcsa.component_sequence_id =
10172: bcb.component_sequence_id
10173: AND bcsa.copy_request_id = p_copy_request_id
10174: AND bcsa.organization_id = to_org_id

Line 10267: FROM bom_copy_structure_actions bcsa

10263: bom_exploder_pub.get_ego_user
10264: )
10265: AND NOT EXISTS (
10266: SELECT 1
10267: FROM bom_copy_structure_actions bcsa
10268: WHERE bcsa.component_sequence_id =
10269: bcb.component_sequence_id
10270: AND bcsa.copy_request_id = p_copy_request_id
10271: AND bcsa.organization_id = to_org_id

Line 10512: FROM bom_copy_structure_actions bcsa

10508: bom_exploder_pub.get_ego_user
10509: )
10510: AND NOT EXISTS (
10511: SELECT 1
10512: FROM bom_copy_structure_actions bcsa
10513: WHERE bcsa.component_sequence_id =
10514: bcb.component_sequence_id
10515: AND bcsa.copy_request_id = p_copy_request_id
10516: AND bcsa.organization_id = to_org_id