DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on BOM_EXPLODER_PUB

Line 1779: bom_exploder_pub.get_ego_user

1775: bom_security_pub.check_item_privilege
1776: ('EGO_VIEW_ITEM',
1777: TO_CHAR (bic.component_item_id),
1778: TO_CHAR (to_org_id),
1779: bom_exploder_pub.get_ego_user
1780: )
1781: AND bic.component_sequence_id = bev.component_sequence_id
1782: AND bev.bill_sequence_id = from_sequence_id
1783: AND bev.parent_sort_order = p_parent_sort_order

Line 2179: bom_exploder_pub.get_ego_user

2175: bom_security_pub.check_item_privilege
2176: ('EGO_VIEW_ITEM',
2177: TO_CHAR (bic.component_item_id),
2178: TO_CHAR (to_org_id),
2179: bom_exploder_pub.get_ego_user
2180: )
2181: AND bic.component_sequence_id = bev.component_sequence_id
2182: AND bev.bill_sequence_id = from_sequence_id
2183: AND bev.parent_sort_order = p_parent_sort_order

Line 2656: bom_exploder_pub.get_ego_user

2652: bom_security_pub.check_item_privilege
2653: ('EGO_VIEW_ITEM',
2654: TO_CHAR (bic.component_item_id),
2655: TO_CHAR (to_org_id),
2656: bom_exploder_pub.get_ego_user
2657: )
2658: AND bic.component_sequence_id = bev.component_sequence_id
2659: AND bev.bill_sequence_id = from_sequence_id
2660: AND bev.parent_sort_order = p_parent_sort_order

Line 3098: bom_exploder_pub.get_ego_user

3094: bom_security_pub.check_item_privilege
3095: ('EGO_VIEW_ITEM',
3096: TO_CHAR (bic.component_item_id),
3097: TO_CHAR (to_org_id),
3098: bom_exploder_pub.get_ego_user
3099: )
3100: AND bic.component_sequence_id = bev.component_sequence_id
3101: AND bev.bill_sequence_id = from_sequence_id
3102: AND bev.parent_sort_order = p_parent_sort_order

Line 3549: bom_exploder_pub.get_ego_user

3545: bom_security_pub.check_item_privilege
3546: ('EGO_VIEW_ITEM',
3547: TO_CHAR (bic.component_item_id),
3548: TO_CHAR (to_org_id),
3549: bom_exploder_pub.get_ego_user
3550: )
3551: AND bic.component_sequence_id = bev.component_sequence_id
3552: AND bev.bill_sequence_id = from_sequence_id
3553: AND bev.parent_sort_order = p_parent_sort_order

Line 3827: bom_exploder_pub.get_ego_user

3823: bom_security_pub.check_item_privilege
3824: ('EGO_VIEW_ITEM',
3825: TO_CHAR (bcb.component_item_id),
3826: TO_CHAR (from_org_id),
3827: bom_exploder_pub.get_ego_user
3828: )
3829: AND msbk1.organization_id = from_org_id
3830: AND bcb.component_sequence_id = bev.component_sequence_id
3831: AND bev.bill_sequence_id = from_sequence_id

Line 3924: bom_exploder_pub.get_ego_user

3920: bom_security_pub.check_item_privilege
3921: ('EGO_VIEW_ITEM',
3922: TO_CHAR (bcb.component_item_id),
3923: TO_CHAR (to_org_id),
3924: bom_exploder_pub.get_ego_user
3925: )
3926: AND msbk1.organization_id = from_org_id
3927: AND bcb.component_sequence_id = bev.component_sequence_id
3928: AND bev.bill_sequence_id = from_sequence_id

Line 4083: bom_exploder_pub.get_ego_user

4079: bom_security_pub.check_item_privilege
4080: ('EGO_VIEW_ITEM',
4081: TO_CHAR (bcb.component_item_id),
4082: TO_CHAR (to_org_id),
4083: bom_exploder_pub.get_ego_user
4084: )
4085: AND NOT EXISTS (
4086: SELECT 1
4087: FROM bom_copy_structure_actions bcsa

Line 4168: bom_exploder_pub.get_ego_user

4164: bom_security_pub.check_item_privilege
4165: ('EGO_VIEW_ITEM',
4166: TO_CHAR (bcb.component_item_id),
4167: TO_CHAR (to_org_id),
4168: bom_exploder_pub.get_ego_user
4169: )
4170: AND NOT EXISTS (
4171: SELECT 1
4172: FROM bom_copy_structure_actions bcsa

Line 4314: bom_exploder_pub.get_ego_user

4310: bom_security_pub.check_item_privilege
4311: ('EGO_VIEW_ITEM',
4312: TO_CHAR (bcb.component_item_id),
4313: TO_CHAR (to_org_id),
4314: bom_exploder_pub.get_ego_user
4315: )
4316: AND NOT EXISTS (
4317: SELECT 1
4318: FROM bom_copy_structure_actions bcsa

Line 4394: bom_exploder_pub.get_ego_user

4390: bom_security_pub.check_item_privilege
4391: ('EGO_VIEW_ITEM',
4392: TO_CHAR (bcb.component_item_id),
4393: TO_CHAR (to_org_id),
4394: bom_exploder_pub.get_ego_user
4395: )
4396: AND NOT EXISTS (
4397: SELECT 1
4398: FROM bom_copy_structure_actions bcsa

Line 4631: bom_exploder_pub.get_ego_user

4627: bom_security_pub.check_item_privilege
4628: ('EGO_VIEW_ITEM',
4629: TO_CHAR (bcb.component_item_id),
4630: TO_CHAR (to_org_id),
4631: bom_exploder_pub.get_ego_user
4632: )
4633: AND NOT EXISTS (
4634: SELECT 1
4635: FROM bom_copy_structure_actions bcsa

Line 8061: bom_exploder_pub.get_ego_user

8057: bom_security_pub.check_item_privilege
8058: ('EGO_VIEW_ITEM',
8059: TO_CHAR (bic.component_item_id),
8060: TO_CHAR (to_org_id),
8061: bom_exploder_pub.get_ego_user
8062: )
8063: AND bic.component_sequence_id = bev.component_sequence_id
8064: AND bev.bill_sequence_id = from_sequence_id
8065: AND bev.parent_sort_order = p_parent_sort_order

Line 8430: bom_exploder_pub.get_ego_user

8426: bom_security_pub.check_item_privilege
8427: ('EGO_VIEW_ITEM',
8428: TO_CHAR (bic.component_item_id),
8429: TO_CHAR (to_org_id),
8430: bom_exploder_pub.get_ego_user
8431: )
8432: AND bic.component_sequence_id = bev.component_sequence_id
8433: AND bev.bill_sequence_id = from_sequence_id
8434: AND bev.parent_sort_order = p_parent_sort_order

Line 8832: bom_exploder_pub.get_ego_user

8828: bom_security_pub.check_item_privilege
8829: ('EGO_VIEW_ITEM',
8830: TO_CHAR (bic.component_item_id),
8831: TO_CHAR (to_org_id),
8832: bom_exploder_pub.get_ego_user
8833: )
8834: AND bic.component_sequence_id = bev.component_sequence_id
8835: AND bev.bill_sequence_id = from_sequence_id
8836: AND bev.parent_sort_order = p_parent_sort_order

Line 9231: bom_exploder_pub.get_ego_user

9227: bom_security_pub.check_item_privilege
9228: ('EGO_VIEW_ITEM',
9229: TO_CHAR (bic.component_item_id),
9230: TO_CHAR (to_org_id),
9231: bom_exploder_pub.get_ego_user
9232: )
9233: AND bic.component_sequence_id = bev.component_sequence_id
9234: AND bev.bill_sequence_id = from_sequence_id
9235: AND bev.parent_sort_order = p_parent_sort_order

Line 9631: bom_exploder_pub.get_ego_user

9627: bom_security_pub.check_item_privilege
9628: ('EGO_VIEW_ITEM',
9629: TO_CHAR (bic.component_item_id),
9630: TO_CHAR (to_org_id),
9631: bom_exploder_pub.get_ego_user
9632: )
9633: AND bic.component_sequence_id = bev.component_sequence_id
9634: AND bev.bill_sequence_id = from_sequence_id
9635: AND bev.parent_sort_order = p_parent_sort_order

Line 9800: bom_exploder_pub.get_ego_user

9796: bom_security_pub.check_item_privilege
9797: ('EGO_VIEW_ITEM',
9798: TO_CHAR (bcb.component_item_id),
9799: TO_CHAR (from_org_id),
9800: bom_exploder_pub.get_ego_user
9801: )
9802: AND msbk1.organization_id = from_org_id
9803: AND bcb.component_sequence_id = bev.component_sequence_id
9804: AND bev.bill_sequence_id = from_sequence_id

Line 9929: bom_exploder_pub.get_ego_user

9925: bom_security_pub.check_item_privilege
9926: ('EGO_VIEW_ITEM',
9927: TO_CHAR (bcb.component_item_id),
9928: TO_CHAR (to_org_id),
9929: bom_exploder_pub.get_ego_user
9930: )
9931: AND msbk1.organization_id = from_org_id
9932: AND bcb.component_sequence_id = bev.component_sequence_id
9933: AND bev.bill_sequence_id = from_sequence_id

Line 10119: bom_exploder_pub.get_ego_user

10115: bom_security_pub.check_item_privilege
10116: ('EGO_VIEW_ITEM',
10117: TO_CHAR (bcb.component_item_id),
10118: TO_CHAR (to_org_id),
10119: bom_exploder_pub.get_ego_user
10120: )
10121: AND NOT EXISTS (
10122: SELECT 1
10123: FROM bom_copy_structure_actions bcsa

Line 10217: bom_exploder_pub.get_ego_user

10213: bom_security_pub.check_item_privilege
10214: ('EGO_VIEW_ITEM',
10215: TO_CHAR (bcb.component_item_id),
10216: TO_CHAR (to_org_id),
10217: bom_exploder_pub.get_ego_user
10218: )
10219: AND NOT EXISTS (
10220: SELECT 1
10221: FROM bom_copy_structure_actions bcsa

Line 10319: bom_exploder_pub.get_ego_user

10315: bom_security_pub.check_item_privilege
10316: ('EGO_VIEW_ITEM',
10317: TO_CHAR (bcb.component_item_id),
10318: TO_CHAR (to_org_id),
10319: bom_exploder_pub.get_ego_user
10320: )
10321: AND NOT EXISTS (
10322: SELECT 1
10323: FROM bom_copy_structure_actions bcsa

Line 10416: bom_exploder_pub.get_ego_user

10412: bom_security_pub.check_item_privilege
10413: ('EGO_VIEW_ITEM',
10414: TO_CHAR (bcb.component_item_id),
10415: TO_CHAR (to_org_id),
10416: bom_exploder_pub.get_ego_user
10417: )
10418: AND NOT EXISTS (
10419: SELECT 1
10420: FROM bom_copy_structure_actions bcsa

Line 10661: bom_exploder_pub.get_ego_user

10657: bom_security_pub.check_item_privilege
10658: ('EGO_VIEW_ITEM',
10659: TO_CHAR (bcb.component_item_id),
10660: TO_CHAR (to_org_id),
10661: bom_exploder_pub.get_ego_user
10662: )
10663: AND NOT EXISTS (
10664: SELECT 1
10665: FROM bom_copy_structure_actions bcsa

Line 11836: AND (bic.disable_date is null OR bic.disable_date > NVL(BOM_EXPLODER_PUB.Get_Explosion_Date, SYSDATE))

11832: bom_structures_b bsb
11833: WHERE bic.bill_sequence_id = bsb.bill_sequence_id
11834: AND bsb.bill_sequence_id = p_bill_seq_id
11835: --Bug 10331803. Should not validate currently disabled components.
11836: AND (bic.disable_date is null OR bic.disable_date > NVL(BOM_EXPLODER_PUB.Get_Explosion_Date, SYSDATE))
11837: AND not exists
11838: (
11839: SELECT 'x'
11840: FROM mtl_system_items s1,