APPS.EGO_ITEM_WS_PVT dependencies on EGO_PUB_WS_FLAT_RECS_S

Line 73: v_sequence_id EGO_PUB_WS_FLAT_RECS.sequence_id%TYPE;

69: v_data_level_id EGO_MTL_SY_ITEMS_EXT_B.data_level_id%TYPE;
70: v_pk1_value EGO_MTL_SY_ITEMS_EXT_B.pk1_value%TYPE;
71: v_pk2_value EGO_MTL_SY_ITEMS_EXT_B.pk2_value%TYPE;
72: v_data_level_name EGO_DATA_LEVEL_VL.user_data_level_name%TYPE;
73: v_sequence_id EGO_PUB_WS_FLAT_RECS.sequence_id%TYPE;
74: v_pk3_value EGO_ODI_WS_ENTITIES.pk3_value%TYPE;
75: v_org_id EGO_PUB_WS_FLAT_RECS.PK2_VALUE%TYPE;
76:
77: -- Performance changes

Line 119: EGO_PUB_WS_FLAT_RECS_S.nextval,

115: VALUE,
116: CREATION_DATE
117: )
118: select
119: EGO_PUB_WS_FLAT_RECS_S.nextval,
120: sessionId,
121: odiSessionId,
122: 'ATTRIBUTE_GROUP',
123: INVENTORY_ITEM_ID,

Line 191: EGO_PUB_WS_FLAT_RECS_S.nextval,

187: VALUE,
188: CREATION_DATE
189: )
190: SELECT
191: EGO_PUB_WS_FLAT_RECS_S.nextval,
192: sessionId,
193: odisessionId,
194: 'UDA',
195: INVENTORY_ITEM_ID ,

Line 447: EGO_PUB_WS_FLAT_RECS_S.nextval,'

443: VALUE,
444: CREATION_DATE
445: )
446: select
447: EGO_PUB_WS_FLAT_RECS_S.nextval,'
448: ||sessionId||','
449: ||odiSessionId||',
450: ''ATTRIBUTE_GROUP'',
451: INVENTORY_ITEM_ID,

Line 525: EGO_PUB_WS_FLAT_RECS_S.nextval,

521: VALUE,
522: CREATION_DATE
523: )
524: select
525: EGO_PUB_WS_FLAT_RECS_S.nextval,
526: sessionId,
527: odiSessionId,
528: 'ATTRIBUTE_GROUP',
529: v_inventory_item_id,

Line 581: EGO_PUB_WS_FLAT_RECS_S.nextval,

577: VALUE,
578: CREATION_DATE
579: )
580: select
581: EGO_PUB_WS_FLAT_RECS_S.nextval,
582: sessionId,
583: odisessionId,
584: 'UDA',
585: flat.PK1_VALUE ,

Line 688: EGO_PUB_WS_FLAT_RECS_S.nextval,

684: CREATION_DATE
685: )
686:
687: SELECT
688: EGO_PUB_WS_FLAT_RECS_S.nextval,
689: sessionId,
690: odisessionId,
691: 'UDA',
692: list.PK1_VALUE ,

Line 831: EGO_PUB_WS_FLAT_RECS_S.nextval,

827: VALUE,
828: CREATION_DATE
829: )
830: select
831: EGO_PUB_WS_FLAT_RECS_S.nextval,
832: sessionId,
833: odisessionId,
834: 'UDA',
835: flat.PK1_VALUE ,

Line 915: EGO_PUB_WS_FLAT_RECS_S.nextval,

911: VALUE,
912: CREATION_DATE
913: )
914: SELECT
915: EGO_PUB_WS_FLAT_RECS_S.nextval,
916: sessionId,
917: odisessionId,
918: 'UDA',
919: list.PK1_VALUE ,

Line 1037: EGO_PUB_WS_FLAT_RECS_S.nextval,

1033: VALUE,
1034: CREATION_DATE
1035: )
1036: select
1037: EGO_PUB_WS_FLAT_RECS_S.nextval,
1038: sessionId,
1039: odisessionId,
1040: 'UDA',
1041: flat.PK1_VALUE ,

Line 1111: EGO_PUB_WS_FLAT_RECS_S.nextval,

1107: VALUE,
1108: CREATION_DATE
1109: )
1110: select
1111: EGO_PUB_WS_FLAT_RECS_S.nextval,
1112: sessionId,
1113: odisessionId,
1114: 'UDA',
1115: list.PK1_VALUE ,

Line 1188: EGO_PUB_WS_FLAT_RECS_S.nextval,

1184: VALUE,
1185: CREATION_DATE
1186: )
1187: select
1188: EGO_PUB_WS_FLAT_RECS_S.nextval,
1189: sessionId,
1190: odisessionId,
1191: 'UDA_TRANSLATIONS',
1192: flat.PK1_VALUE ,

Line 1254: EGO_PUB_WS_FLAT_RECS_S.nextval,

1250: VALUE,
1251: CREATION_DATE
1252: )
1253: select
1254: EGO_PUB_WS_FLAT_RECS_S.nextval,
1255: sessionId,
1256: odisessionId,
1257: 'UDA_TRANSLATIONS',
1258: list.PK1_VALUE ,

Line 1339: EGO_PUB_WS_FLAT_RECS_S.nextval,

1335: VALUE,
1336: CREATION_DATE
1337: )
1338: SELECT
1339: EGO_PUB_WS_FLAT_RECS_S.nextval,
1340: sessionId,
1341: odiSessionId,
1342: 'GTIN_CROSS_REFERENCE',
1343: flat.PK1_VALUE,

Line 1405: EGO_PUB_WS_FLAT_RECS_S.nextval,

1401: VALUE,
1402: CREATION_DATE
1403: )
1404: SELECT
1405: EGO_PUB_WS_FLAT_RECS_S.nextval,
1406: sessionId,
1407: odiSessionId,
1408: 'GTIN_CROSS_REFERENCE_TRANSLATIONS',
1409: flat.PK1_VALUE,

Line 1614: EGO_PUB_WS_FLAT_RECS_S.nextval,

1610: VALUE,
1611: CREATION_DATE
1612: )
1613: SELECT
1614: EGO_PUB_WS_FLAT_RECS_S.nextval,
1615: sessionId ,
1616: odisessionId,
1617: 'TRANSACTION_ATTRIBUTE',
1618: j.item_id,