APPS.INV_LPN_TRX_PUB dependencies on WMS_LPN_CONTENTS

Line 239: FROM wms_lpn_contents

235: AND organization_id = v_mmtt_rec.organization_id;
236:
237: SELECT sum(primary_quantity) , sum(quantity)
238: INTO l_wlc_prim_qty , l_wlc_trx_qty
239: FROM wms_lpn_contents
240: where parent_lpn_id = v_mmtt_rec.content_lpn_id
241: and lot_number = v_mmtt_rec.lot_number
242: and inventory_item_id = v_mmtt_rec.inventory_item_id
243: and organization_id = v_mmtt_rec.organization_id

Line 1063: -- which will be transferred to MOQD or WMS_LPN_CONTENTS later.

1059: -- because for WIP putaway where cost group will be derived later, so
1060: -- comingle_check will fail if cost_group_id is NULL
1061: -- Bug 2886342. Add Or condition of p_mmtt.cost_group_id IS NOT NULL
1062: -- This is the cases when cost group suggestion has been stamped on MMTT
1063: -- which will be transferred to MOQD or WMS_LPN_CONTENTS later.
1064: -- assign_cost_group will not be called, so need to do the comingling check here
1065: IF (l_skip_comingle_check = 2)
1066: AND((curlpnrec.cost_group_id IS NOT NULL)
1067: OR(p_mmtt.cost_group_id IS NOT NULL)) THEN

Line 1181: -- which will be transferred to MOQD or WMS_LPN_CONTENTS later.

1177: -- because for WIP putaway where cost group will be derived later, so
1178: -- comingle_check will fail if cost_group_id is NULL
1179: -- Bug 2886342. Add Or condition of p_mmtt.cost_group_id IS NOT NULL
1180: -- This is the cases when cost group suggestion has been stamped on MMTT
1181: -- which will be transferred to MOQD or WMS_LPN_CONTENTS later.
1182: -- assign_cost_group will not be called, so need to do the comingling check here
1183:
1184: IF (l_skip_comingle_check = 2)
1185: AND((curlpnrec.cost_group_id IS NOT NULL)

Line 5349: SELECT interface_transaction_id FROM rcv_transactions_interface rti,wms_lpn_contents wlc

5345:
5346: -- End of bug 7226314,7355087
5347:
5348: CURSOR c_rtv_exists (p_lpn_id NUMBER ,p_organization_id NUMBER ) IS --RTV Change 16197273
5349: SELECT interface_transaction_id FROM rcv_transactions_interface rti,wms_lpn_contents wlc
5350: WHERE rti.interface_transaction_id = wlc.source_header_id
5351: AND rti.processing_status_code = 'WSH_INTERFACED'
5352: AND rti.to_organization_id = wlc.organization_id
5353: AND wlc.parent_lpn_id = p_lpn_id

Line 6010: UPDATE wms_lpn_contents

6006: ELSE
6007: --lpn is same as transfer lpn just need to null the source name,
6008: --source header id and cost group columns for all items inside
6009: --that lpn.
6010: UPDATE wms_lpn_contents
6011: SET source_name = NULL
6012: , source_header_id = NULL
6013: , cost_group_id = NULL
6014: WHERE parent_lpn_id = p_lpn_id;

Line 6104: UPDATE wms_lpn_contents

6100: );
6101: ELSE
6102: --lpn is same as transfer lpn just need to null the cost group column
6103: --for all items inside that lpn.
6104: UPDATE wms_lpn_contents
6105: SET cost_group_id = NULL
6106: WHERE parent_lpn_id = p_lpn_id;
6107:
6108: --Same needs to be done in the serial numbers table

Line 6264: UPDATE wms_lpn_contents

6260: inv_log_util.TRACE('It is WIP LPN completion and content LPN is not null or txfer LPN equals LPN id', 'INV_LPN_TRX_PUB', 9);
6261: inv_log_util.TRACE('Updating WLC to make source_type_id null', 'INV_LPN_TRX_PUB', 9);
6262: END IF;
6263:
6264: UPDATE wms_lpn_contents
6265: SET source_type_id = NULL
6266: WHERE parent_lpn_id = NVL(p_content_lpn_id, p_lpn_id);
6267: END IF;
6268: --BUG13656377 end

Line 6454: UPDATE wms_lpn_contents

6450: inv_log_util.TRACE('p_sr_Code is:'||p_serial_control_code ,'INV_LPN_TRX_PUB', 9);
6451: END IF;
6452: IF (p_transaction_action_id = inv_globals.g_action_intransitreceipt AND
6453: p_serial_control_code = 6 ) THEN
6454: UPDATE wms_lpn_contents
6455: SET serial_summary_entry = 2
6456: WHERE parent_lpn_id = p_lpn_id
6457: AND organization_id = p_organization_id
6458: AND inventory_item_id = p_inventory_item_id

Line 6462: UPDATE wms_lpn_contents

6458: AND inventory_item_id = p_inventory_item_id
6459: AND serial_summary_entry <> 2 ;
6460: END IF;
6461:
6462: UPDATE wms_lpn_contents
6463: SET cost_group_id = p_cost_group_id
6464: WHERE organization_id = p_organization_id
6465: AND inventory_item_id = p_inventory_item_id
6466: AND parent_lpn_id = p_lpn_id

Line 6856: UPDATE wms_lpn_contents

6852:
6853:
6854: -- Bug 6733277 :Update WLC's serial_summary entry to 2 is serial control is 6 and transaction in intransit receipt
6855: IF (p_transaction_action_id = inv_globals.g_action_intransitreceipt AND p_serial_control_code = 6 ) THEN
6856: UPDATE wms_lpn_contents
6857: SET serial_summary_entry = 2
6858: WHERE parent_lpn_id = p_content_lpn_id
6859: AND organization_id = p_organization_id
6860: AND inventory_item_id = p_inventory_item_id