DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

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

1724: END IF ;
1725: END IF ;
1726: END IF;
1727:
1728: SELECT mtl_material_transactions_s.NEXTVAL INTO l_hdr_id FROM dual;
1729:
1730: IF (g_trace_on = 1) THEN mydebug('l_hdr_id ' || l_hdr_id ); END IF;
1731:
1732: OPEN lpn_csr;

Line 1806: mtl_material_transactions_s.NEXTVAL,

1802: posting_flag,
1803: wms_task_type) -- bug 2879208
1804: VALUES
1805: (l_hdr_id,
1806: mtl_material_transactions_s.NEXTVAL,
1807: 'Y',
1808: 3,
1809: sysdate,
1810: p_user_id,

Line 2779: (mtl_material_transactions_s.nextval,

2775: operation_plan_id,
2776: wms_task_type,
2777: transfer_lpn_id)
2778: VALUES
2779: (mtl_material_transactions_s.nextval,
2780: mtl_material_transactions_s.NEXTVAL,
2781: 'Y',
2782: 2,
2783: sysdate,

Line 2780: mtl_material_transactions_s.NEXTVAL,

2776: wms_task_type,
2777: transfer_lpn_id)
2778: VALUES
2779: (mtl_material_transactions_s.nextval,
2780: mtl_material_transactions_s.NEXTVAL,
2781: 'Y',
2782: 2,
2783: sysdate,
2784: p_user_id,