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.EGO_ITEM_WS_PVT dependencies on EGO_PUB_WS_FLAT_RECS

Line 33: * for a given business entity level in to the table EGO_PUB_WS_FLAT_RECS.

29: e_no_org_details EXCEPTION;
30: e_no_rev_details EXCEPTION;
31:
32: /* Procedure Inserts the UDA values for the publishing items,
33: * for a given business entity level in to the table EGO_PUB_WS_FLAT_RECS.
34: */
35:
36: /* Below are the different values stored in EGO_PUB_WS_FLAT_RECS for AG, UDA and transalateble UDAs.
37:

Line 36: /* Below are the different values stored in EGO_PUB_WS_FLAT_RECS for AG, UDA and transalateble UDAs.

32: /* Procedure Inserts the UDA values for the publishing items,
33: * for a given business entity level in to the table EGO_PUB_WS_FLAT_RECS.
34: */
35:
36: /* Below are the different values stored in EGO_PUB_WS_FLAT_RECS for AG, UDA and transalateble UDAs.
37:
38: Column in AG UDA UDA-For Translatable value
39: Flat Rec table
40: ============== ============= ============== =============================

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 75: v_org_id EGO_PUB_WS_FLAT_RECS.PK2_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
78: -- TYPE DYNAMIC_CUR IS REF CURSOR;
79: -- v_dynamic_cursor DYNAMIC_CUR;

Line 101: insert into EGO_PUB_WS_FLAT_RECS

97: -- If datalevel is 43101 (i.e Item level), then get the varinat attributes for style items if any.
98: IF (dataLevelId = 43101)
99: THEN
100: -- Insert the variant AG details for style items if any.
101: insert into EGO_PUB_WS_FLAT_RECS
102: (
103: SEQUENCE_ID,
104: SESSION_ID,
105: ODI_SESSION_ID,

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 151: EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat

147: ent.PK3_VALUE, FLAT.SEQUENCE_ID
148: FROM
149: ego_attrs_v attr, EGO_STYLE_VARIANT_ATTR_VS var,
150: ego_attr_groups_v agv, mtl_system_items_b msib,
151: EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat
152: WHERE
153: var.ATTRIBUTE_ID = attr.ATTR_ID
154: AND agv.ATTR_GROUP_NAME = attr.ATTR_GROUP_NAME
155: AND attr.APPLICATION_ID = agv.APPLICATION_ID

Line 173: insert INTO EGO_PUB_WS_FLAT_RECS

169: /* If any varinat AG details are inserted in above query, then execute the below query to insert their
170: attributes and value set names.
171: */
172: IF (SQL%ROWCOUNT > 0 ) THEN
173: insert INTO EGO_PUB_WS_FLAT_RECS
174: (
175: SEQUENCE_ID,
176: SESSION_ID,
177: ODI_SESSION_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 226: EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat

222: var.VALUE_SET_ID , ent.PK3_VALUE ,
223: FLAT.SEQUENCE_ID
224: FROM
225: ego_attrs_v attr, EGO_STYLE_VARIANT_ATTR_VS var, ego_attr_groups_v agv,
226: EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat
227: WHERE
228: var.ATTRIBUTE_ID = attr.ATTR_ID
229: AND agv.ATTR_GROUP_NAME = attr.ATTR_GROUP_NAME
230: AND attr.APPLICATION_ID = agv.APPLICATION_ID

Line 262: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||

258: ' flat.SEQUENCE_ID , '||
259: ' ent.PK3_VALUE AS "PK3_VALUE" , '||
260: ' flat.PK2_VALUE AS "ORG_ID" '||
261: ' FROM EGO_MTL_SY_ITEMS_EXT_B egob, EGO_ATTR_GROUPS_V AG, '||
262: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||
263: ' WHERE egob.DATA_LEVEL_ID = edlv.DATA_LEVEL_ID '||
264: ' AND AG.APPLICATION_ID = edlv.APPLICATION_ID '||
265: ' AND egob.ATTR_GROUP_ID = AG.ATTR_GROUP_ID '||
266: ' AND ent.SESSION_ID = :session_id '||

Line 289: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||

285: ' flat.SEQUENCE_ID , '||
286: ' ent.PK3_VALUE AS "PK3_VALUE" , '||
287: ' flat.PK2_VALUE AS "ORG_ID" '||
288: ' FROM EGO_MTL_SY_ITEMS_EXT_B egob, EGO_ATTR_GROUPS_V AG, ego_attr_group_dl AGDL, mtl_system_items_b msib, '||
289: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||
290: ' WHERE egob.DATA_LEVEL_ID = edlv.DATA_LEVEL_ID '||
291: ' AND egob.DATA_LEVEL_ID = AGDL.DATA_LEVEL_ID '||
292: ' AND AG.APPLICATION_ID = edlv.APPLICATION_ID '||
293: ' AND egob.ATTR_GROUP_ID = AG.ATTR_GROUP_ID '||

Line 429: v_query_string := 'insert into EGO_PUB_WS_FLAT_RECS

425: -- Bug 11738301 : End
426:
427: -- Performance Changes : Start
428: -- Instead of loop, having single query to insert AG details.
429: v_query_string := 'insert into EGO_PUB_WS_FLAT_RECS
430: (
431: SEQUENCE_ID,
432: SESSION_ID,
433: ODI_SESSION_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 507: insert into EGO_PUB_WS_FLAT_RECS

503: EXIT WHEN v_dynamic_cursor%NOTFOUND;
504:
505:
506:
507: insert into EGO_PUB_WS_FLAT_RECS
508: (
509: SEQUENCE_ID,
510: SESSION_ID,
511: ODI_SESSION_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 562: insert into EGO_PUB_WS_FLAT_RECS

558: -- If any AG details are inserted into flat table then only process for attribute details.
559: IF (SQL%ROWCOUNT > 0 ) THEN
560: /* Insert The UDA values other than translated char value, for all the AGs that were inserted into the flat table for the corresponding level */
561: /*
562: insert into EGO_PUB_WS_FLAT_RECS
563: (
564: SEQUENCE_ID,
565: SESSION_ID,
566: ODI_SESSION_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 622: ) list , EGO_PUB_WS_FLAT_RECS flat ,

618: ATTRIBUTE_DATETIME_VALUE,
619: null as TRANSLATED_CHAR_VALUE,
620: REVISION_ID
621: FROM ego_all_attr_base_v)
622: ) list , EGO_PUB_WS_FLAT_RECS flat ,
623: ego_attrs_v eav, EGO_VALUE_SET_VALUES_V evsv
624: WHERE
625: list.ATTRIBUTEGROUP_ID = FLAT.REF1_VALUE
626: AND list.EXTENSION_ID = FLAT.REF2_VALUE

Line 668: insert into EGO_PUB_WS_FLAT_RECS

664:
665: */
666:
667: /* Insert The UDA values other than translated char value, for all the AGs that were inserted into the flat table for the corresponding level */
668: insert into EGO_PUB_WS_FLAT_RECS
669: (
670: SEQUENCE_ID,
671: SESSION_ID,
672: ODI_SESSION_ID,

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 768: FROM EGO_MTL_SY_ITEMS_EXT_B UDA , EGO_PUB_WS_FLAT_RECS flat ,

764: 'D_EXT_ATTR6', UDA.D_EXT_ATTR6, 'D_EXT_ATTR7', UDA.D_EXT_ATTR7, 'D_EXT_ATTR8', UDA.D_EXT_ATTR8, 'D_EXT_ATTR9', UDA.D_EXT_ATTR9, 'D_EXT_ATTR10', UDA.D_EXT_ATTR10)
765: ), 'MM/DD/YYYY HH24:MI:SS'
766: ) AS ATTRIBUTE_DATETIME_VALUE
767:
768: FROM EGO_MTL_SY_ITEMS_EXT_B UDA , EGO_PUB_WS_FLAT_RECS flat ,
769: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG
770:
771: WHERE UDA.ATTR_GROUP_ID = AG.ATTR_GROUP_ID
772: AND AGC.APPLICATION_ID = AG.APPLICATION_ID

Line 812: insert into EGO_PUB_WS_FLAT_RECS

808:
809:
810: -- Bug 8791039 : Below Query added to get the UDAs having NULL Values
811: /*
812: insert into EGO_PUB_WS_FLAT_RECS
813: (
814: SEQUENCE_ID,
815: SESSION_ID,
816: ODI_SESSION_ID,

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 872: ) list , EGO_PUB_WS_FLAT_RECS flat ,

868: ATTRIBUTE_DATETIME_VALUE,
869: null as TRANSLATED_CHAR_VALUE,
870: REVISION_ID
871: FROM ego_all_attr_base_v)
872: ) list , EGO_PUB_WS_FLAT_RECS flat ,
873: ego_attrs_v eav
874: WHERE
875: list.ATTRIBUTEGROUP_ID = FLAT.REF1_VALUE
876: AND list.EXTENSION_ID = FLAT.REF2_VALUE

Line 896: insert into EGO_PUB_WS_FLAT_RECS

892:
893: */
894:
895: -- Bug 8791039 : Below Query added to get the UDAs having NULL Values
896: insert into EGO_PUB_WS_FLAT_RECS
897: (
898: SEQUENCE_ID,
899: SESSION_ID,
900: ODI_SESSION_ID,

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 995: FROM EGO_MTL_SY_ITEMS_EXT_B UDA , EGO_PUB_WS_FLAT_RECS flat ,

991: 'D_EXT_ATTR6', UDA.D_EXT_ATTR6, 'D_EXT_ATTR7', UDA.D_EXT_ATTR7, 'D_EXT_ATTR8', UDA.D_EXT_ATTR8, 'D_EXT_ATTR9', UDA.D_EXT_ATTR9, 'D_EXT_ATTR10', UDA.D_EXT_ATTR10)
992: ), 'MM/DD/YYYY HH24:MI:SS'
993: ) AS ATTRIBUTE_DATETIME_VALUE
994:
995: FROM EGO_MTL_SY_ITEMS_EXT_B UDA , EGO_PUB_WS_FLAT_RECS flat ,
996: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG
997:
998: WHERE UDA.ATTR_GROUP_ID = AG.ATTR_GROUP_ID
999: AND AGC.APPLICATION_ID = AG.APPLICATION_ID

Line 1017: insert into EGO_PUB_WS_FLAT_RECS

1013: AND list.ATTRIBUTE_DATETIME_VALUE IS NULL;
1014:
1015: /* Insert the translated char value if exists, for all the AGs that were inserted into the flat table for the corresponding level */
1016: /*
1017: insert into EGO_PUB_WS_FLAT_RECS
1018: (
1019: SEQUENCE_ID,
1020: SESSION_ID,
1021: ODI_SESSION_ID,

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 1070: ) list , EGO_PUB_WS_FLAT_RECS flat

1066: ATTRIBUTE_TRANSLATABLE_VALUE as TRANSLATED_CHAR_VALUE,
1067: REVISION_ID
1068: FROM ego_all_attr_lang_v
1069: where language = userenv('LANG'))
1070: ) list , EGO_PUB_WS_FLAT_RECS flat
1071: , ego_attrs_v eav -- Bug 9542020
1072: WHERE
1073: list.ATTRIBUTEGROUP_ID = FLAT.REF1_VALUE
1074: AND list.EXTENSION_ID = FLAT.REF2_VALUE

Line 1091: insert into EGO_PUB_WS_FLAT_RECS

1087: AND FLAT.ENTITY_TYPE = 'ATTRIBUTE_GROUP';
1088: */
1089:
1090: /* Insert the translated char value if exists, for all the AGs that were inserted into the flat table for the corresponding level */
1091: insert into EGO_PUB_WS_FLAT_RECS
1092: (
1093: SEQUENCE_ID,
1094: SESSION_ID,
1095: ODI_SESSION_ID,

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 1154: FROM EGO_MTL_SY_ITEMS_EXT_TL UDA , EGO_PUB_WS_FLAT_RECS flat ,

1150: 'TL_EXT_ATTR31', UDA.TL_EXT_ATTR31, 'TL_EXT_ATTR32', UDA.TL_EXT_ATTR32, 'TL_EXT_ATTR33', UDA.TL_EXT_ATTR33, 'TL_EXT_ATTR34', UDA.TL_EXT_ATTR34,
1151: 'TL_EXT_ATTR35', UDA.TL_EXT_ATTR35, 'TL_EXT_ATTR36', UDA.TL_EXT_ATTR36, 'TL_EXT_ATTR37', UDA.TL_EXT_ATTR37, 'TL_EXT_ATTR38', UDA.TL_EXT_ATTR38,
1152: 'TL_EXT_ATTR39', UDA.TL_EXT_ATTR39, 'TL_EXT_ATTR40', UDA.TL_EXT_ATTR40 )
1153: ) AS ATTRIBUTE_TRANSLATABLE_VALUE
1154: FROM EGO_MTL_SY_ITEMS_EXT_TL UDA , EGO_PUB_WS_FLAT_RECS flat ,
1155: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG
1156:
1157: WHERE UDA.ATTR_GROUP_ID = AG.ATTR_GROUP_ID
1158: AND AGC.APPLICATION_ID = AG.APPLICATION_ID

Line 1173: insert into EGO_PUB_WS_FLAT_RECS

1169: ) list;
1170:
1171: /* Insert Translatable values ( for Trabslated char value )*/
1172: /*
1173: insert into EGO_PUB_WS_FLAT_RECS
1174: (
1175: SEQUENCE_ID,
1176: SESSION_ID,
1177: ODI_SESSION_ID,

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 1215: ) list , EGO_PUB_WS_FLAT_RECS flat , EGO_PUB_WS_CONFIG CONFIG

1211: ATTRIBUTE_TRANSLATABLE_VALUE as TRANSLATED_CHAR_VALUE,
1212: REVISION_ID,
1213: LANGUAGE
1214: FROM ego_all_attr_lang_v ealv
1215: ) list , EGO_PUB_WS_FLAT_RECS flat , EGO_PUB_WS_CONFIG CONFIG
1216: WHERE list.ATTRIBUTEGROUP_ID = FLAT.REF1_VALUE
1217: AND list.EXTENSION_ID = FLAT.REF2_VALUE
1218: AND list.INVENTORY_ITEM_ID = FLAT.PK1_VALUE
1219: AND list.ORGANIZATION_ID = Decode(dataLevelId , 43101, flat.REF4_VALUE,

Line 1239: insert into EGO_PUB_WS_FLAT_RECS

1235: */
1236:
1237: IF (SQL%ROWCOUNT > 0) Then
1238: /* Insert Translatable values ( for Trabslated char value )*/
1239: insert into EGO_PUB_WS_FLAT_RECS
1240: (
1241: SEQUENCE_ID,
1242: SESSION_ID,
1243: ODI_SESSION_ID,

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 1288: FROM EGO_MTL_SY_ITEMS_EXT_TL UDA , EGO_PUB_WS_FLAT_RECS flat ,

1284: 'TL_EXT_ATTR35', UDA.TL_EXT_ATTR35, 'TL_EXT_ATTR36', UDA.TL_EXT_ATTR36, 'TL_EXT_ATTR37', UDA.TL_EXT_ATTR37, 'TL_EXT_ATTR38', UDA.TL_EXT_ATTR38,
1285: 'TL_EXT_ATTR39', UDA.TL_EXT_ATTR39, 'TL_EXT_ATTR40', UDA.TL_EXT_ATTR40 )
1286: ) AS ATTRIBUTE_TRANSLATABLE_VALUE
1287:
1288: FROM EGO_MTL_SY_ITEMS_EXT_TL UDA , EGO_PUB_WS_FLAT_RECS flat ,
1289: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG , EGO_PUB_WS_CONFIG CONFIG
1290:
1291: WHERE UDA.ATTR_GROUP_ID = AG.ATTR_GROUP_ID
1292: AND AGC.APPLICATION_ID = AG.APPLICATION_ID

Line 1315: -- This Procedure inserts the GTIN XRef Deetails associated to an Item into the table EGO_PUB_WS_FLAT_RECS

1311: END IF; -- if for v_publish_udas
1312: END;
1313:
1314:
1315: -- This Procedure inserts the GTIN XRef Deetails associated to an Item into the table EGO_PUB_WS_FLAT_RECS
1316: PROCEDURE POPULATE_GTIN_DETAILS
1317: (sessionId IN NUMBER,
1318: odisessionId IN NUMBER
1319: )

Line 1324: insert into EGO_PUB_WS_FLAT_RECS

1320: AS
1321:
1322: BEGIN
1323:
1324: insert into EGO_PUB_WS_FLAT_RECS
1325: (
1326: SEQUENCE_ID,
1327: SESSION_ID,
1328: ODI_SESSION_ID,

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 1378: EGO_PUB_WS_FLAT_RECS flat

1374: AND MCR1.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
1375: AND MSIK.ORGANIZATION_ID = MP1.MASTER_ORGANIZATION_ID
1376: AND MSIK.PRIMARY_UOM_CODE = trim(MCR1.UOM_CODE)
1377: ) A,
1378: EGO_PUB_WS_FLAT_RECS flat
1379: WHERE EgoGtinEO.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID
1380: AND MP.ORGANIZATION_ID = flat.PK2_VALUE
1381: AND MSIB.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
1382: AND EgoGtinEO.CROSS_REFERENCE_TYPE = 'GTIN'

Line 1391: insert into EGO_PUB_WS_FLAT_RECS

1387: AND flat.SESSION_ID = sessionId ;
1388:
1389:
1390: /* Insert Translations for GTIN */
1391: insert into EGO_PUB_WS_FLAT_RECS
1392: (
1393: SEQUENCE_ID,
1394: SESSION_ID,
1395: ODI_SESSION_ID,

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 1418: FROM MTL_CROSS_REFERENCES_TL mcrt, EGO_PUB_WS_CONFIG config, EGO_PUB_WS_FLAT_RECS flat

1414: config.char_value AS "Language" ,
1415: mcrt.DESCRIPTION AS "GTINDescription"
1416: ).getclobval() ,
1417: SYSDATE
1418: FROM MTL_CROSS_REFERENCES_TL mcrt, EGO_PUB_WS_CONFIG config, EGO_PUB_WS_FLAT_RECS flat
1419: WHERE config.SESSION_ID = flat.SESSION_ID
1420: AND config.PARAMETER_NAME = 'LANGUAGE_CODE'
1421: AND config.CHAR_VALUE = mcrt.LANGUAGE
1422: AND flat.ENTITY_TYPE = 'GTIN_CROSS_REFERENCE'

Line 1432: -- This Procedure inserts the Transaction Attributee details associated to an Item into the table EGO_PUB_WS_FLAT_RECS

1428:
1429: END;
1430:
1431:
1432: -- This Procedure inserts the Transaction Attributee details associated to an Item into the table EGO_PUB_WS_FLAT_RECS
1433: PROCEDURE POPULATE_Transaction_Attrs
1434: (sessionId IN NUMBER,
1435: odisessionId IN NUMBER
1436: )

Line 1512: FROM EGO_PUB_WS_FLAT_RECS

1508:
1509: CURSOR cur_item_list
1510: IS
1511: SELECT sequence_id,parent_sequence_id,pk1_value item_id ,pk2_value org_id, pk3_value rev_id
1512: FROM EGO_PUB_WS_FLAT_RECS
1513: WHERE session_id= sessionId
1514: AND odi_session_id = odisessionId
1515: AND entity_type ='ITEM_REVISION';
1516:

Line 1599: INSERT INTO EGO_PUB_WS_FLAT_RECS

1595:
1596:
1597: FOR i IN l_item_ta_metadata_tbl.first..l_item_ta_metadata_tbl.last
1598: LOOP
1599: INSERT INTO EGO_PUB_WS_FLAT_RECS
1600: (
1601: SEQUENCE_ID,
1602: SESSION_ID,
1603: ODI_SESSION_ID,

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,