APPS.WMS_CONSOLIDATION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 1733: SELECT mtl_material_transactions_s.NEXTVAL INTO l_hdr_id FROM dual;

1729: END IF ;
1730: END IF ;
1731: END IF;
1732:
1733: SELECT mtl_material_transactions_s.NEXTVAL INTO l_hdr_id FROM dual;
1734:
1735: IF (g_trace_on = 1) THEN mydebug('l_hdr_id ' || l_hdr_id ); END IF;
1736:
1737: OPEN lpn_csr;

Line 1811: mtl_material_transactions_s.NEXTVAL,

1807: posting_flag,
1808: wms_task_type) -- bug 2879208
1809: VALUES
1810: (l_hdr_id,
1811: mtl_material_transactions_s.NEXTVAL,
1812: 'Y',
1813: 3,
1814: sysdate,
1815: p_user_id,

Line 2873: (mtl_material_transactions_s.nextval,

2869: operation_plan_id,
2870: wms_task_type,
2871: transfer_lpn_id)
2872: VALUES
2873: (mtl_material_transactions_s.nextval,
2874: mtl_material_transactions_s.NEXTVAL,
2875: 'Y',
2876: 2,
2877: sysdate,

Line 2874: mtl_material_transactions_s.NEXTVAL,

2870: wms_task_type,
2871: transfer_lpn_id)
2872: VALUES
2873: (mtl_material_transactions_s.nextval,
2874: mtl_material_transactions_s.NEXTVAL,
2875: 'Y',
2876: 2,
2877: sysdate,
2878: p_user_id,