1718: AND bcb.bill_sequence_id = bic.bill_sequence_id
1719: )
1720: AND 'T' = bev.access_flag
1721: AND 'T' =
1722: bom_security_pub.check_item_privilege
1723: ('EGO_VIEW_ITEM',
1724: TO_CHAR (bic.component_item_id),
1725: TO_CHAR (to_org_id),
1726: bom_exploder_pub.get_ego_user
2118: AND bcb.bill_sequence_id = bic.bill_sequence_id
2119: )
2120: AND 'T' = bev.access_flag
2121: AND 'T' =
2122: bom_security_pub.check_item_privilege
2123: ('EGO_VIEW_ITEM',
2124: TO_CHAR (bic.component_item_id),
2125: TO_CHAR (to_org_id),
2126: bom_exploder_pub.get_ego_user
2595: AND bcb.bill_sequence_id = bic.bill_sequence_id
2596: )
2597: AND 'T' = bev.access_flag
2598: AND 'T' =
2599: bom_security_pub.check_item_privilege
2600: ('EGO_VIEW_ITEM',
2601: TO_CHAR (bic.component_item_id),
2602: TO_CHAR (to_org_id),
2603: bom_exploder_pub.get_ego_user
3036: AND bcb.bill_sequence_id = bic.bill_sequence_id
3037: )
3038: AND 'T' = bev.access_flag
3039: AND 'T' =
3040: bom_security_pub.check_item_privilege
3041: ('EGO_VIEW_ITEM',
3042: TO_CHAR (bic.component_item_id),
3043: TO_CHAR (to_org_id),
3044: bom_exploder_pub.get_ego_user
3487: AND bcb.bill_sequence_id = bic.bill_sequence_id
3488: )
3489: AND 'T' = bev.access_flag
3490: AND 'T' =
3491: bom_security_pub.check_item_privilege
3492: ('EGO_VIEW_ITEM',
3493: TO_CHAR (bic.component_item_id),
3494: TO_CHAR (to_org_id),
3495: bom_exploder_pub.get_ego_user
3757: WHERE bcb.bill_sequence_id = x_from_sequence_id
3758: AND bcb.component_item_id = msbk1.inventory_item_id
3759: AND bcb.component_item_id <> to_item_id
3760: AND 'T' <>
3761: bom_security_pub.check_item_privilege
3762: ('EGO_VIEW_ITEM',
3763: TO_CHAR (bcb.component_item_id),
3764: TO_CHAR (from_org_id),
3765: bom_exploder_pub.get_ego_user
3854: WHERE bcb.bill_sequence_id = x_from_sequence_id
3855: AND bcb.component_item_id = msbk1.inventory_item_id
3856: AND bcb.component_item_id <> to_item_id
3857: AND 'T' <>
3858: bom_security_pub.check_item_privilege
3859: ('EGO_VIEW_ITEM',
3860: TO_CHAR (bcb.component_item_id),
3861: TO_CHAR (to_org_id),
3862: bom_exploder_pub.get_ego_user
4013: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
4014: )
4015: AND 'T' = bev.access_flag
4016: AND 'T' =
4017: bom_security_pub.check_item_privilege
4018: ('EGO_VIEW_ITEM',
4019: TO_CHAR (bcb.component_item_id),
4020: TO_CHAR (to_org_id),
4021: bom_exploder_pub.get_ego_user
4098: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
4099: )
4100: AND 'T' = bev.access_flag
4101: AND 'T' =
4102: bom_security_pub.check_item_privilege
4103: ('EGO_VIEW_ITEM',
4104: TO_CHAR (bcb.component_item_id),
4105: TO_CHAR (to_org_id),
4106: bom_exploder_pub.get_ego_user
4244: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
4245: )
4246: AND 'T' = bev.access_flag
4247: AND 'T' =
4248: bom_security_pub.check_item_privilege
4249: ('EGO_VIEW_ITEM',
4250: TO_CHAR (bcb.component_item_id),
4251: TO_CHAR (to_org_id),
4252: bom_exploder_pub.get_ego_user
4324: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
4325: )
4326: AND 'T' = bev.access_flag
4327: AND 'T' =
4328: bom_security_pub.check_item_privilege
4329: ('EGO_VIEW_ITEM',
4330: TO_CHAR (bcb.component_item_id),
4331: TO_CHAR (to_org_id),
4332: bom_exploder_pub.get_ego_user
4561: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
4562: )
4563: AND 'T' = bev.access_flag
4564: AND 'T' =
4565: bom_security_pub.check_item_privilege
4566: ('EGO_VIEW_ITEM',
4567: TO_CHAR (bcb.component_item_id),
4568: TO_CHAR (to_org_id),
4569: bom_exploder_pub.get_ego_user
7912: AND bcb.bill_sequence_id = bic.bill_sequence_id
7913: )
7914: AND 'T' = bev.access_flag
7915: AND 'T' =
7916: bom_security_pub.check_item_privilege
7917: ('EGO_VIEW_ITEM',
7918: TO_CHAR (bic.component_item_id),
7919: TO_CHAR (to_org_id),
7920: bom_exploder_pub.get_ego_user
8280: AND bcb.bill_sequence_id = bic.bill_sequence_id
8281: )
8282: AND 'T' = bev.access_flag
8283: AND 'T' =
8284: bom_security_pub.check_item_privilege
8285: ('EGO_VIEW_ITEM',
8286: TO_CHAR (bic.component_item_id),
8287: TO_CHAR (to_org_id),
8288: bom_exploder_pub.get_ego_user
8681: AND bcb.bill_sequence_id = bic.bill_sequence_id
8682: )
8683: AND 'T' = bev.access_flag
8684: AND 'T' =
8685: bom_security_pub.check_item_privilege
8686: ('EGO_VIEW_ITEM',
8687: TO_CHAR (bic.component_item_id),
8688: TO_CHAR (to_org_id),
8689: bom_exploder_pub.get_ego_user
9079: AND bcb.bill_sequence_id = bic.bill_sequence_id
9080: )
9081: AND 'T' = bev.access_flag
9082: AND 'T' =
9083: bom_security_pub.check_item_privilege
9084: ('EGO_VIEW_ITEM',
9085: TO_CHAR (bic.component_item_id),
9086: TO_CHAR (to_org_id),
9087: bom_exploder_pub.get_ego_user
9478: AND bcb.bill_sequence_id = bic.bill_sequence_id
9479: )
9480: AND 'T' = bev.access_flag
9481: AND 'T' =
9482: bom_security_pub.check_item_privilege
9483: ('EGO_VIEW_ITEM',
9484: TO_CHAR (bic.component_item_id),
9485: TO_CHAR (to_org_id),
9486: bom_exploder_pub.get_ego_user
9639: WHERE bcb.bill_sequence_id = x_from_sequence_id
9640: AND bcb.component_item_id = msbk1.inventory_item_id
9641: AND bcb.component_item_id <> to_item_id
9642: AND 'T' <>
9643: bom_security_pub.check_item_privilege
9644: ('EGO_VIEW_ITEM',
9645: TO_CHAR (bcb.component_item_id),
9646: TO_CHAR (from_org_id),
9647: bom_exploder_pub.get_ego_user
9768: WHERE bcb.bill_sequence_id = x_from_sequence_id
9769: AND bcb.component_item_id = msbk1.inventory_item_id
9770: AND bcb.component_item_id <> to_item_id
9771: AND 'T' <>
9772: bom_security_pub.check_item_privilege
9773: ('EGO_VIEW_ITEM',
9774: TO_CHAR (bcb.component_item_id),
9775: TO_CHAR (to_org_id),
9776: bom_exploder_pub.get_ego_user
9958: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
9959: )
9960: AND 'T' = bev.access_flag
9961: AND 'T' =
9962: bom_security_pub.check_item_privilege
9963: ('EGO_VIEW_ITEM',
9964: TO_CHAR (bcb.component_item_id),
9965: TO_CHAR (to_org_id),
9966: bom_exploder_pub.get_ego_user
10056: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
10057: )
10058: AND 'T' = bev.access_flag
10059: AND 'T' =
10060: bom_security_pub.check_item_privilege
10061: ('EGO_VIEW_ITEM',
10062: TO_CHAR (bcb.component_item_id),
10063: TO_CHAR (to_org_id),
10064: bom_exploder_pub.get_ego_user
10158: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
10159: )
10160: AND 'T' = bev.access_flag
10161: AND 'T' =
10162: bom_security_pub.check_item_privilege
10163: ('EGO_VIEW_ITEM',
10164: TO_CHAR (bcb.component_item_id),
10165: TO_CHAR (to_org_id),
10166: bom_exploder_pub.get_ego_user
10255: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
10256: )
10257: AND 'T' = bev.access_flag
10258: AND 'T' =
10259: bom_security_pub.check_item_privilege
10260: ('EGO_VIEW_ITEM',
10261: TO_CHAR (bcb.component_item_id),
10262: TO_CHAR (to_org_id),
10263: bom_exploder_pub.get_ego_user
10500: AND bcb1.bill_sequence_id = bcb.bill_sequence_id
10501: )
10502: AND 'T' = bev.access_flag
10503: AND 'T' =
10504: bom_security_pub.check_item_privilege
10505: ('EGO_VIEW_ITEM',
10506: TO_CHAR (bcb.component_item_id),
10507: TO_CHAR (to_org_id),
10508: bom_exploder_pub.get_ego_user