eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_SERIAL_NUMBER_PUB dependencies on MTL_SERIAL_TAGGING_ASSIGNMENTS

Line 6506: FROM MTL_SERIAL_TAGGING_ASSIGNMENTS

6502: l_tagged := inv_cache.get_serial_tagged(p_organization_id, p_inventory_item_id, l_txn_type_id);
6503: /*
6504: BEGIN
6505: SELECT Count(1) INTO l_tagged
6506: FROM MTL_SERIAL_TAGGING_ASSIGNMENTS
6507: WHERE ORGANIZATION_ID = p_organization_id
6508: AND INVENTORY_ITEM_ID = p_inventory_item_id
6509: AND TRANSACTION_TYPE_ID = p_txn_type_id
6510: AND rownum = 1;

Line 6594: WHERE EXISTS (SELECT 1 FROM mtl_serial_tagging_assignments

6590: IF p_template_id IS NOT NULL THEN
6591: BEGIN
6592: SELECT 2 INTO l_exists
6593: FROM DUAL
6594: WHERE EXISTS (SELECT 1 FROM mtl_serial_tagging_assignments
6595: WHERE NVL(organization_id,-1) = NVL(p_organization_id,-1)
6596: AND template_id = p_template_id
6597: );
6598: EXCEPTION

Line 6608: WHERE EXISTS (SELECT 1 FROM mtl_serial_tagging_assignments

6604: ELSE
6605: BEGIN
6606: SELECT 2 INTO l_exists
6607: FROM DUAL
6608: WHERE EXISTS (SELECT 1 FROM mtl_serial_tagging_assignments
6609: WHERE organization_id = p_organization_id
6610: AND inventory_item_id = p_inventory_item_id
6611: );
6612: EXCEPTION

Line 6678: INSERT INTO mtl_serial_tagging_assignments

6674: END IF;
6675:
6676: IF p_from_item_id IS NOT NULL AND p_to_item_id IS NOT NULL THEN
6677: BEGIN
6678: INSERT INTO mtl_serial_tagging_assignments
6679: ( ORGANIZATION_ID , INVENTORY_ITEM_ID , TEMPLATE_ID , TRANSACTION_TYPE_ID
6680: , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , CONTEXT )
6681: SELECT p_to_org_id , p_to_item_id , p_to_template_id , transaction_type_id
6682: , l_userid , SYSDATE , l_userid , SYSDATE , l_loginid , context

Line 6683: FROM mtl_serial_tagging_assignments msta1

6679: ( ORGANIZATION_ID , INVENTORY_ITEM_ID , TEMPLATE_ID , TRANSACTION_TYPE_ID
6680: , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , CONTEXT )
6681: SELECT p_to_org_id , p_to_item_id , p_to_template_id , transaction_type_id
6682: , l_userid , SYSDATE , l_userid , SYSDATE , l_loginid , context
6683: FROM mtl_serial_tagging_assignments msta1
6684: WHERE organization_id = p_from_org_id
6685: AND inventory_item_id = p_from_item_id
6686: AND NOT EXISTS (SELECT 1
6687: FROM mtl_serial_tagging_assignments msta2

Line 6687: FROM mtl_serial_tagging_assignments msta2

6683: FROM mtl_serial_tagging_assignments msta1
6684: WHERE organization_id = p_from_org_id
6685: AND inventory_item_id = p_from_item_id
6686: AND NOT EXISTS (SELECT 1
6687: FROM mtl_serial_tagging_assignments msta2
6688: WHERE msta2.organization_id = p_to_org_id
6689: AND msta2.inventory_item_id = p_to_item_id
6690: AND msta2.transaction_type_id = msta1.transaction_type_id
6691: )

Line 6703: INSERT INTO mtl_serial_tagging_assignments

6699: END IF;
6700: END;
6701: ELSIF p_from_item_id IS NOT NULL AND p_to_template_id IS NOT NULL THEN
6702: BEGIN
6703: INSERT INTO mtl_serial_tagging_assignments
6704: ( ORGANIZATION_ID , INVENTORY_ITEM_ID , TEMPLATE_ID , TRANSACTION_TYPE_ID
6705: , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , CONTEXT )
6706: SELECT p_to_org_id , p_to_item_id , p_to_template_id , transaction_type_id
6707: , l_userid , SYSDATE , l_userid , SYSDATE , l_loginid , context

Line 6708: FROM mtl_serial_tagging_assignments msta1

6704: ( ORGANIZATION_ID , INVENTORY_ITEM_ID , TEMPLATE_ID , TRANSACTION_TYPE_ID
6705: , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , CONTEXT )
6706: SELECT p_to_org_id , p_to_item_id , p_to_template_id , transaction_type_id
6707: , l_userid , SYSDATE , l_userid , SYSDATE , l_loginid , context
6708: FROM mtl_serial_tagging_assignments msta1
6709: WHERE organization_id = p_from_org_id
6710: AND inventory_item_id = p_from_item_id
6711: AND NOT EXISTS (SELECT 1
6712: FROM mtl_serial_tagging_assignments msta2

Line 6712: FROM mtl_serial_tagging_assignments msta2

6708: FROM mtl_serial_tagging_assignments msta1
6709: WHERE organization_id = p_from_org_id
6710: AND inventory_item_id = p_from_item_id
6711: AND NOT EXISTS (SELECT 1
6712: FROM mtl_serial_tagging_assignments msta2
6713: WHERE NVL(msta2.organization_id,-1) = NVL(p_to_org_id,-1)
6714: AND msta2.template_id = p_to_template_id
6715: AND msta2.transaction_type_id = msta1.transaction_type_id
6716: )

Line 6728: INSERT INTO mtl_serial_tagging_assignments

6724: END IF;
6725: END;
6726: ELSIF p_from_template_id IS NOT NULL AND p_to_item_id IS NOT NULL THEN
6727: BEGIN
6728: INSERT INTO mtl_serial_tagging_assignments
6729: ( ORGANIZATION_ID , INVENTORY_ITEM_ID , TEMPLATE_ID , TRANSACTION_TYPE_ID
6730: , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , CONTEXT )
6731: SELECT p_to_org_id , p_to_item_id , p_to_template_id , transaction_type_id
6732: , l_userid , SYSDATE , l_userid , SYSDATE , l_loginid , context

Line 6733: FROM mtl_serial_tagging_assignments msta1

6729: ( ORGANIZATION_ID , INVENTORY_ITEM_ID , TEMPLATE_ID , TRANSACTION_TYPE_ID
6730: , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , CONTEXT )
6731: SELECT p_to_org_id , p_to_item_id , p_to_template_id , transaction_type_id
6732: , l_userid , SYSDATE , l_userid , SYSDATE , l_loginid , context
6733: FROM mtl_serial_tagging_assignments msta1
6734: WHERE NVL(organization_id,-1) = NVL(p_from_org_id,-1)
6735: AND template_id = p_from_template_id
6736: AND NOT EXISTS (SELECT 1
6737: FROM mtl_serial_tagging_assignments msta2

Line 6737: FROM mtl_serial_tagging_assignments msta2

6733: FROM mtl_serial_tagging_assignments msta1
6734: WHERE NVL(organization_id,-1) = NVL(p_from_org_id,-1)
6735: AND template_id = p_from_template_id
6736: AND NOT EXISTS (SELECT 1
6737: FROM mtl_serial_tagging_assignments msta2
6738: WHERE msta2.organization_id = p_to_org_id
6739: AND msta2.inventory_item_id = p_to_item_id
6740: AND msta2.transaction_type_id = msta1.transaction_type_id
6741: )

Line 6753: INSERT INTO mtl_serial_tagging_assignments

6749: END IF;
6750: END;
6751: ELSIF p_from_template_id IS NOT NULL AND p_to_template_id IS NOT NULL THEN
6752: BEGIN
6753: INSERT INTO mtl_serial_tagging_assignments
6754: ( ORGANIZATION_ID , INVENTORY_ITEM_ID , TEMPLATE_ID , TRANSACTION_TYPE_ID
6755: , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , CONTEXT )
6756: SELECT p_to_org_id , p_to_item_id , p_to_template_id , transaction_type_id
6757: , l_userid , SYSDATE , l_userid , SYSDATE , l_loginid , context

Line 6758: FROM mtl_serial_tagging_assignments msta1

6754: ( ORGANIZATION_ID , INVENTORY_ITEM_ID , TEMPLATE_ID , TRANSACTION_TYPE_ID
6755: , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , CONTEXT )
6756: SELECT p_to_org_id , p_to_item_id , p_to_template_id , transaction_type_id
6757: , l_userid , SYSDATE , l_userid , SYSDATE , l_loginid , context
6758: FROM mtl_serial_tagging_assignments msta1
6759: WHERE NVL(organization_id,-1) = NVL(p_from_org_id,-1)
6760: AND template_id = p_from_template_id
6761: AND NOT EXISTS (SELECT 1
6762: FROM mtl_serial_tagging_assignments msta2

Line 6762: FROM mtl_serial_tagging_assignments msta2

6758: FROM mtl_serial_tagging_assignments msta1
6759: WHERE NVL(organization_id,-1) = NVL(p_from_org_id,-1)
6760: AND template_id = p_from_template_id
6761: AND NOT EXISTS (SELECT 1
6762: FROM mtl_serial_tagging_assignments msta2
6763: WHERE NVL(msta2.organization_id,-1) = NVL(p_to_org_id,-1)
6764: AND msta2.template_id = p_to_template_id
6765: AND msta2.transaction_type_id = msta1.transaction_type_id
6766: )

Line 6808: DELETE FROM MTL_SERIAL_TAGGING_ASSIGNMENTS

6804:
6805: IF ( p_inventory_item_id IS NULL
6806: AND p_template_id IS NOT NULL)
6807: THEN
6808: DELETE FROM MTL_SERIAL_TAGGING_ASSIGNMENTS
6809: WHERE template_id = p_template_id
6810: AND NVL(organization_id,-99) = NVL(p_organization_id,-99);
6811:
6812: ELSIF ( p_inventory_item_id IS NOT NULL

Line 6816: DELETE FROM MTL_SERIAL_TAGGING_ASSIGNMENTS

6812: ELSIF ( p_inventory_item_id IS NOT NULL
6813: AND p_organization_id IS NOT NULL
6814: AND p_template_id IS NULL)
6815: THEN
6816: DELETE FROM MTL_SERIAL_TAGGING_ASSIGNMENTS
6817: WHERE inventory_item_id = p_inventory_item_id
6818: AND organization_id = p_organization_id;
6819: ELSE
6820: x_return_status := fnd_api.g_ret_sts_error;