APPS.WMS_CONSOLIDATION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

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 1781: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

1777: AND ROWNUM = 1;
1778: IF (g_trace_on = 1) THEN mydebug('l_item_id ' || l_item_id); END IF;
1779:
1780:
1781: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
1782: (TRANSACTION_HEADER_ID,
1783: TRANSACTION_TEMP_ID,
1784: PROCESS_FLAG,
1785: transaction_status,

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 2481: mtl_material_transactions_temp mmtt,

2477: AND NOT exists
2478: (
2479: SELECT 1
2480: FROM
2481: mtl_material_transactions_temp mmtt,
2482: wsh_delivery_details wdd1,
2483: wsh_delivery_assignments_v wda2
2484: WHERE wda2.delivery_id = p_delivery_id
2485: AND wda2.delivery_detail_id = wdd1.delivery_detail_id

Line 2616: mtl_material_transactions_temp mmtt

2612: SELECT mmtt.transaction_temp_id
2613: INTO l_temp_id
2614: FROM
2615: wms_dispatched_tasks wdt,
2616: mtl_material_transactions_temp mmtt
2617: WHERE mmtt.organization_id = p_org_id
2618: AND mmtt.transfer_lpn_id = p_lpn_id
2619: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
2620: AND ROWNUM = 1;

Line 2729: From Mtl_Material_Transactions Mmt,

2725: l_orig_loc,
2726: l_op_plan_id,
2727: l_from_sub,
2728: l_from_loc
2729: From Mtl_Material_Transactions Mmt,
2730: Wms_Dispatched_Tasks_History Wdth,
2731: Wsh_Delivery_Details_Ob_Grp_v Wdd,
2732: Wsh_Delivery_Assignments Wda,
2733: Wsh_Delivery_Details_Ob_Grp_v Wddc,

Line 2842: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

2838: AND wlpn.outermost_lpn_id = p_lpn_id
2839: AND wlpn.organization_id = p_org_id
2840: AND ROWNUM = 1;
2841:
2842: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
2843: (TRANSACTION_HEADER_ID,
2844: TRANSACTION_TEMP_ID,
2845: PROCESS_FLAG,
2846: transaction_status,

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,