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 1786: FROM bom_copy_structure_actions bcsa

1782: AND bev.bill_sequence_id = from_sequence_id
1783: AND bev.parent_sort_order = p_parent_sort_order
1784: AND NOT EXISTS (
1785: SELECT 1
1786: FROM bom_copy_structure_actions bcsa
1787: WHERE bcsa.component_sequence_id =
1788: bic.component_sequence_id
1789: AND bcsa.copy_request_id = p_copy_request_id
1790: AND bcsa.organization_id = to_org_id

Line 2186: FROM bom_copy_structure_actions bcsa

2182: AND bev.bill_sequence_id = from_sequence_id
2183: AND bev.parent_sort_order = p_parent_sort_order
2184: AND NOT EXISTS (
2185: SELECT 1
2186: FROM bom_copy_structure_actions bcsa
2187: WHERE bcsa.component_sequence_id =
2188: bic.component_sequence_id
2189: AND bcsa.copy_request_id = p_copy_request_id
2190: AND bcsa.organization_id = to_org_id

Line 2663: FROM bom_copy_structure_actions bcsa

2659: AND bev.bill_sequence_id = from_sequence_id
2660: AND bev.parent_sort_order = p_parent_sort_order
2661: AND NOT EXISTS (
2662: SELECT 1
2663: FROM bom_copy_structure_actions bcsa
2664: WHERE bcsa.component_sequence_id =
2665: bic.component_sequence_id
2666: AND bcsa.copy_request_id = p_copy_request_id
2667: AND bcsa.organization_id = to_org_id

Line 3105: FROM bom_copy_structure_actions bcsa

3101: AND bev.bill_sequence_id = from_sequence_id
3102: AND bev.parent_sort_order = p_parent_sort_order
3103: AND NOT EXISTS (
3104: SELECT 1
3105: FROM bom_copy_structure_actions bcsa
3106: WHERE bcsa.component_sequence_id =
3107: bic.component_sequence_id
3108: AND bcsa.copy_request_id = p_copy_request_id
3109: AND bcsa.organization_id = to_org_id

Line 3556: FROM bom_copy_structure_actions bcsa

3552: AND bev.bill_sequence_id = from_sequence_id
3553: AND bev.parent_sort_order = p_parent_sort_order
3554: AND NOT EXISTS (
3555: SELECT 1
3556: FROM bom_copy_structure_actions bcsa
3557: WHERE bcsa.component_sequence_id =
3558: bic.component_sequence_id
3559: AND bcsa.copy_request_id = p_copy_request_id
3560: AND bcsa.organization_id = to_org_id

Line 3852: FROM bom_copy_structure_actions bcsa

3848: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
3849: )
3850: AND NOT EXISTS (
3851: SELECT 1
3852: FROM bom_copy_structure_actions bcsa
3853: WHERE bcsa.component_sequence_id =
3854: bcb.component_sequence_id
3855: AND bcsa.copy_request_id = p_copy_request_id
3856: AND bcsa.organization_id = to_org_id

Line 3949: FROM bom_copy_structure_actions bcsa

3945: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
3946: )
3947: AND NOT EXISTS (
3948: SELECT 1
3949: FROM bom_copy_structure_actions bcsa
3950: WHERE bcsa.component_sequence_id =
3951: bcb.component_sequence_id
3952: AND bcsa.copy_request_id = p_copy_request_id
3953: AND bcsa.organization_id = to_org_id

Line 4087: FROM bom_copy_structure_actions bcsa

4083: bom_exploder_pub.get_ego_user
4084: )
4085: AND NOT EXISTS (
4086: SELECT 1
4087: FROM bom_copy_structure_actions bcsa
4088: WHERE bcsa.component_sequence_id =
4089: bcb.component_sequence_id
4090: AND bcsa.copy_request_id = p_copy_request_id
4091: AND bcsa.organization_id = to_org_id

Line 4172: FROM bom_copy_structure_actions bcsa

4168: bom_exploder_pub.get_ego_user
4169: )
4170: AND NOT EXISTS (
4171: SELECT 1
4172: FROM bom_copy_structure_actions bcsa
4173: WHERE bcsa.component_sequence_id =
4174: bcb.component_sequence_id
4175: AND bcsa.copy_request_id = p_copy_request_id
4176: AND bcsa.organization_id = to_org_id

Line 4318: FROM bom_copy_structure_actions bcsa

4314: bom_exploder_pub.get_ego_user
4315: )
4316: AND NOT EXISTS (
4317: SELECT 1
4318: FROM bom_copy_structure_actions bcsa
4319: WHERE bcsa.component_sequence_id =
4320: bcb.component_sequence_id
4321: AND bcsa.copy_request_id = p_copy_request_id
4322: AND bcsa.organization_id = to_org_id

Line 4398: FROM bom_copy_structure_actions bcsa

4394: bom_exploder_pub.get_ego_user
4395: )
4396: AND NOT EXISTS (
4397: SELECT 1
4398: FROM bom_copy_structure_actions bcsa
4399: WHERE bcsa.component_sequence_id =
4400: bcb.component_sequence_id
4401: AND bcsa.copy_request_id = p_copy_request_id
4402: AND bcsa.organization_id = to_org_id

Line 4635: FROM bom_copy_structure_actions bcsa

4631: bom_exploder_pub.get_ego_user
4632: )
4633: AND NOT EXISTS (
4634: SELECT 1
4635: FROM bom_copy_structure_actions bcsa
4636: WHERE bcsa.component_sequence_id =
4637: bcb.component_sequence_id
4638: AND bcsa.copy_request_id = p_copy_request_id
4639: AND bcsa.organization_id = to_org_id

Line 6576: FROM bom_copy_structure_actions bcsa

6572: AND msib.organization_id = c_org_id)
6573: AND ( NOT EXISTS (
6574: -- Direct Component Action is exclude
6575: SELECT 1
6576: FROM bom_copy_structure_actions bcsa
6577: WHERE bcsa.copy_request_id = p_copy_request_id
6578: AND bcsa.organization_id = p_to_org_id
6579: AND bcsa.component_sequence_id = bev.component_sequence_id
6580: AND bcsa.component_exception_action = 1

Line 6585: FROM bom_copy_structure_actions bcsa, bom_copy_explosions_v bcev

6581: )
6582: OR NOT EXISTS (
6583: -- Structure Action is exclude
6584: SELECT 1
6585: FROM bom_copy_structure_actions bcsa, bom_copy_explosions_v bcev
6586: WHERE bcsa.copy_request_id = p_copy_request_id
6587: AND bcsa.organization_id = p_to_org_id
6588: AND bcsa.structure_exception_action = 1
6589: AND bcsa.component_sequence_id = bcev.component_sequence_id

Line 6757: DELETE FROM bom_copy_structure_actions

6753:
6754: PROCEDURE purge_processed_copy_requests (p_request_status IN VARCHAR2)
6755: IS
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);

Line 8068: FROM bom_copy_structure_actions bcsa

8064: AND bev.bill_sequence_id = from_sequence_id
8065: AND bev.parent_sort_order = p_parent_sort_order
8066: AND NOT EXISTS (
8067: SELECT 1
8068: FROM bom_copy_structure_actions bcsa
8069: WHERE bcsa.component_sequence_id =
8070: bic.component_sequence_id
8071: AND bcsa.copy_request_id = p_copy_request_id
8072: AND bcsa.organization_id = to_org_id

Line 8437: FROM bom_copy_structure_actions bcsa

8433: AND bev.bill_sequence_id = from_sequence_id
8434: AND bev.parent_sort_order = p_parent_sort_order
8435: AND NOT EXISTS (
8436: SELECT 1
8437: FROM bom_copy_structure_actions bcsa
8438: WHERE bcsa.component_sequence_id =
8439: bic.component_sequence_id
8440: AND bcsa.copy_request_id = p_copy_request_id
8441: AND bcsa.organization_id = to_org_id

Line 8839: FROM bom_copy_structure_actions bcsa

8835: AND bev.bill_sequence_id = from_sequence_id
8836: AND bev.parent_sort_order = p_parent_sort_order
8837: AND NOT EXISTS (
8838: SELECT 1
8839: FROM bom_copy_structure_actions bcsa
8840: WHERE bcsa.component_sequence_id =
8841: bic.component_sequence_id
8842: AND bcsa.copy_request_id = p_copy_request_id
8843: AND bcsa.organization_id = to_org_id

Line 9238: FROM bom_copy_structure_actions bcsa

9234: AND bev.bill_sequence_id = from_sequence_id
9235: AND bev.parent_sort_order = p_parent_sort_order
9236: AND NOT EXISTS (
9237: SELECT 1
9238: FROM bom_copy_structure_actions bcsa
9239: WHERE bcsa.component_sequence_id =
9240: bic.component_sequence_id
9241: AND bcsa.copy_request_id = p_copy_request_id
9242: AND bcsa.organization_id = to_org_id

Line 9638: FROM bom_copy_structure_actions bcsa

9634: AND bev.bill_sequence_id = from_sequence_id
9635: AND bev.parent_sort_order = p_parent_sort_order
9636: AND NOT EXISTS (
9637: SELECT 1
9638: FROM bom_copy_structure_actions bcsa
9639: WHERE bcsa.component_sequence_id =
9640: bic.component_sequence_id
9641: AND bcsa.copy_request_id = p_copy_request_id
9642: AND bcsa.organization_id = to_org_id

Line 9825: FROM bom_copy_structure_actions bcsa

9821: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
9822: )
9823: AND NOT EXISTS (
9824: SELECT 1
9825: FROM bom_copy_structure_actions bcsa
9826: WHERE bcsa.component_sequence_id =
9827: bcb.component_sequence_id
9828: AND bcsa.copy_request_id = p_copy_request_id
9829: AND bcsa.organization_id = to_org_id

Line 9954: FROM bom_copy_structure_actions bcsa

9950: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
9951: )
9952: AND NOT EXISTS (
9953: SELECT 1
9954: FROM bom_copy_structure_actions bcsa
9955: WHERE bcsa.component_sequence_id =
9956: bcb.component_sequence_id
9957: AND bcsa.copy_request_id = p_copy_request_id
9958: AND bcsa.organization_id = to_org_id

Line 10123: FROM bom_copy_structure_actions bcsa

10119: bom_exploder_pub.get_ego_user
10120: )
10121: AND NOT EXISTS (
10122: SELECT 1
10123: FROM bom_copy_structure_actions bcsa
10124: WHERE bcsa.component_sequence_id =
10125: bcb.component_sequence_id
10126: AND bcsa.copy_request_id = p_copy_request_id
10127: AND bcsa.organization_id = to_org_id

Line 10221: FROM bom_copy_structure_actions bcsa

10217: bom_exploder_pub.get_ego_user
10218: )
10219: AND NOT EXISTS (
10220: SELECT 1
10221: FROM bom_copy_structure_actions bcsa
10222: WHERE bcsa.component_sequence_id =
10223: bcb.component_sequence_id
10224: AND bcsa.copy_request_id = p_copy_request_id
10225: AND bcsa.organization_id = to_org_id

Line 10323: FROM bom_copy_structure_actions bcsa

10319: bom_exploder_pub.get_ego_user
10320: )
10321: AND NOT EXISTS (
10322: SELECT 1
10323: FROM bom_copy_structure_actions bcsa
10324: WHERE bcsa.component_sequence_id =
10325: bcb.component_sequence_id
10326: AND bcsa.copy_request_id = p_copy_request_id
10327: AND bcsa.organization_id = to_org_id

Line 10420: FROM bom_copy_structure_actions bcsa

10416: bom_exploder_pub.get_ego_user
10417: )
10418: AND NOT EXISTS (
10419: SELECT 1
10420: FROM bom_copy_structure_actions bcsa
10421: WHERE bcsa.component_sequence_id =
10422: bcb.component_sequence_id
10423: AND bcsa.copy_request_id = p_copy_request_id
10424: AND bcsa.organization_id = to_org_id

Line 10665: FROM bom_copy_structure_actions bcsa

10661: bom_exploder_pub.get_ego_user
10662: )
10663: AND NOT EXISTS (
10664: SELECT 1
10665: FROM bom_copy_structure_actions bcsa
10666: WHERE bcsa.component_sequence_id =
10667: bcb.component_sequence_id
10668: AND bcsa.copy_request_id = p_copy_request_id
10669: AND bcsa.organization_id = to_org_id