[Home] [Help]
103: created_by,
104: creation_Date
105: )
106: select
107: WMS_ELS_EXP_RESOURCE_S.NEXTVAL,
108: to_organization_id,
109: 1,--Inbound
110: 1,--Recieve
111: 1,--Reciept
194: last_update_login,
195: created_by,
196: creation_Date
197: )
198: select wms_els_exp_resource_s.nextval,
199: ship_from_org_id,
200: 1, -- Inbound
201: 1, -- Recieving
202: 1, -- Reciept
279: created_by,
280: creation_Date
281: )
282: select
283: WMS_ELS_EXP_RESOURCE_S.NEXTVAL,
284: organization_id,
285: 1,--Inbound
286: 2,--Putaway
287: 3,--Drop
352: created_by,
353: creation_Date
354: )
355: select
356: WMS_ELS_EXP_RESOURCE_S.NEXTVAL,
357: organization_id,
358: 1,--Inbound
359: 2,--Putaway
360: 3,--Drop
425: created_by,
426: creation_Date
427: )
428: select
429: WMS_ELS_EXP_RESOURCE_S.NEXTVAL,
430: organization_id,
431: 1,--Inbound
432: 2,--Putaway
433: 3,--Drop
498: created_by,
499: creation_Date
500: )
501: select
502: WMS_ELS_EXP_RESOURCE_S.NEXTVAL,
503: organization_id,
504: 1,--Inbound
505: 2,--Putaway
506: 3,--Drop
571: created_by,
572: creation_Date
573: )
574: select
575: WMS_ELS_EXP_RESOURCE_S.NEXTVAL,
576: organization_id,
577: 2,-- Manufacturing
578: 2,-- putaway
579: 3,--DROP
644: last_update_login,
645: created_by,
646: creation_Date
647: )
648: select wms_els_exp_resource_s.nextval,
649: mcce.organization_id,
650: 4,-- Warehousing
651: 5,-- Counting
652: 4,--Count
723: last_update_login,
724: created_by,
725: creation_Date
726: )
727: select wms_els_exp_resource_s.nextval,
728: mmtt.organization_id,
729: (CASE when (
730: ( Transaction_Type_Id = 52
731: and Transaction_Action_Id =28
963: last_update_login,
964: created_by,
965: creation_Date
966: )
967: select wms_els_exp_resource_s.nextval,
968: mmtt.organization_id,
969: (CASE when (
970: ( Transaction_Type_Id = 52
971: and Transaction_Action_Id =28
1205: last_update_login,
1206: created_by,
1207: creation_Date
1208: )
1209: select wms_els_exp_resource_s.nextval,
1210: mmtt.organization_id,
1211: (CASE when (
1212: ( Transaction_Type_Id = 52
1213: and Transaction_Action_Id =28
1416: last_update_login,
1417: created_by,
1418: creation_Date
1419: )
1420: select wms_els_exp_resource_s.nextval,
1421: mmtt.organization_id,
1422: (CASE when (
1423: ( Transaction_Type_Id = 52
1424: and Transaction_Action_Id =28
1613: last_update_login,
1614: created_by,
1615: creation_Date
1616: )
1617: select wms_els_exp_resource_s.nextval,
1618: mmtt2.organization_id,
1619: (CASE when (
1620: ( mmtt2.Transaction_Type_Id = 52
1621: and mmtt2.Transaction_Action_Id =28
1825: last_update_login,
1826: created_by,
1827: creation_Date
1828: )
1829: SELECT WMS_ELS_EXP_RESOURCE_S.NEXTVAL,
1830: organization_id,
1831: activity_id,
1832: activity_detail_id,
1833: operation_id,
1923: last_update_login,
1924: created_by,
1925: creation_Date
1926: )
1927: select WMS_ELS_EXP_RESOURCE_S.NEXTVAL,
1928: organization_id,
1929: activity_id,
1930: activity_detail_id,
1931: operation_id,
2378: l_where_clause := l_where_clause || ' AND group_id = :group_id ';
2379: END IF;
2380: */
2381:
2382: l_sql :='UPDATE wms_els_exp_resource SET '
2383: ||' els_data_id = :els_data_id'
2384: ||' ,source_zone_id = :source_zone'
2385: ||' ,destination_zone_id = :destination_zone'
2386: ||' ,item_category_id = :item_category'
2552: -- now update all txns having els_data_id as NULL as non_attributed
2553: l_update_count := NULL;
2554:
2555:
2556: UPDATE wms_els_exp_resource SET unattributed_flag = 1
2557: WHERE els_data_id IS NULL AND organization_id = p_org_id;
2558:
2559: l_update_count := SQL%ROWCOUNT;
2560: