APPS.EGO_ITEM_PVT dependencies on MTL_SERIAL_TAGGING_ASSIGNMENTS

Line 6365: from mtl_serial_tagging_assignments

6361: IF p_template_id IS NULL THEN
6362:
6363: select 'Y'
6364: into l_exists
6365: from mtl_serial_tagging_assignments
6366: where organization_id = p_organization_id
6367: and inventory_item_id = p_inventory_item_id
6368: and transaction_type_id = l_transaction_type_id;
6369:

Line 6374: from mtl_serial_tagging_assignments

6370: ELSE
6371:
6372: select 'Y'
6373: into l_exists
6374: from mtl_serial_tagging_assignments
6375: where nvl(organization_id,-1) = nvl(p_organization_id,-1)
6376: and template_id = p_template_id
6377: and transaction_type_id = l_transaction_type_id;
6378:

Line 6396: INSERT INTO MTL_SERIAL_TAGGING_ASSIGNMENTS

6392:
6393: --
6394: -- Insert the data
6395: --
6396: INSERT INTO MTL_SERIAL_TAGGING_ASSIGNMENTS
6397: (
6398: organization_id
6399: ,inventory_item_id
6400: ,template_id

Line 6507: DELETE FROM MTL_SERIAL_TAGGING_ASSIGNMENTS

6503: -- Delete the data
6504: --
6505: IF p_template_id is null THEN
6506:
6507: DELETE FROM MTL_SERIAL_TAGGING_ASSIGNMENTS
6508: WHERE organization_id = p_organization_id
6509: AND inventory_item_id = p_inventory_item_id
6510: AND transaction_type_id = l_transaction_type_id;
6511:

Line 6514: DELETE FROM MTL_SERIAL_TAGGING_ASSIGNMENTS

6510: AND transaction_type_id = l_transaction_type_id;
6511:
6512: ELSE
6513:
6514: DELETE FROM MTL_SERIAL_TAGGING_ASSIGNMENTS
6515: WHERE nvl(organization_id,-1) = nvl(p_organization_id,-1)
6516: AND template_id = p_template_id
6517: AND transaction_type_id = l_transaction_type_id;
6518: