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_LABEL_PVT1 dependencies on INV_LABEL_PVT1

Line 1: PACKAGE BODY inv_label_pvt1 AS

1: PACKAGE BODY inv_label_pvt1 AS
2: /* $Header: INVLAP1B.pls 120.50.12020000.3 2013/03/01 12:39:19 ashsisin ship $ */
3:
4: label_b CONSTANT VARCHAR2(50) := ' 5: label_e CONSTANT VARCHAR2(50) := '' || fnd_global.local_chr(10);

Line 529: , inv_label_pvt1.get_uom_code(

525: , rti.to_organization_id organization_id
526: , rti.cost_group_id cost_group_id
527: , pol.project_id project_id
528: , pol.task_id task_id
529: , inv_label_pvt1.get_uom_code(
530: rti.to_organization_id
531: , rti.item_id
532: , rti.unit_of_measure
533: ) uom

Line 580: WHERE inv_label_pvt1.check_rti_id(

576: AND hrl1.location_id(+) = rti.deliver_to_location_id
577: AND rrh.routing_header_id(+) = rti.routing_header_id
578: AND hrl2.location_id(+) = rti.location_id) rti2
579: /***************************************/
580: WHERE inv_label_pvt1.check_rti_id(
581: rti2.interface_transaction_id
582: , mtlt.lot_number
583: , rti.item_revision
584: ) = 'N'

Line 652: , (inv_label_pvt1.get_uom_code(

648: , SUM(NVL(rls.quantity, rt.quantity)) quantity -- Reverted to original code as part of Bug#4516067
649: -- Commented as part of the Bug#4516067 and added the code to fetch secondary_quantity from rls instead of mtln
650: -- , SUM(NVL(mtln.SECONDARY_TRANSACTION_QUANTITY, rt.SECONDARY_QUANTITY)) secondary_quantity -- fabdi 4373856
651: , SUM(NVL(rls.SECONDARY_QUANTITY, rt.SECONDARY_QUANTITY)) secondary_quantity -- fabdi 4373856
652: , (inv_label_pvt1.get_uom_code(
653: rt.organization_id
654: , rsl.item_id
655: , rsl.unit_of_measure
656: )

Line 658: , (inv_label_pvt1.get_uom2_code(

654: , rsl.item_id
655: , rsl.unit_of_measure
656: )
657: ) uom
658: , (inv_label_pvt1.get_uom2_code(
659: rt.organization_id
660: , rsl.item_id
661: )
662: ) secondary_uom -- bug 4373856

Line 791: , inv_label_pvt1.get_uom_code(

787: -- , pod.task_id --Commented as part of Bug# 3586116
788: -- Added by joabraha bug 3472150
789: , rsh.receipt_num
790: --
791: , inv_label_pvt1.get_uom_code(
792: rt.organization_id
793: , rsl.item_id
794: , rsl.unit_of_measure
795: )

Line 796: , (inv_label_pvt1.get_uom2_code(

792: rt.organization_id
793: , rsl.item_id
794: , rsl.unit_of_measure
795: )
796: , (inv_label_pvt1.get_uom2_code(
797: rt.organization_id
798: , rsl.item_id
799: ) -- bug 4373856
800: )

Line 801: , (inv_label_pvt1.get_uom2_code(

797: rt.organization_id
798: , rsl.item_id
799: ) -- bug 4373856
800: )
801: , (inv_label_pvt1.get_uom2_code(
802: rt.organization_id
803: , rsl.item_id
804: )
805: ) -- bug 4373856

Line 859: , (inv_label_pvt1.get_uom_code(

855: , rsh.receipt_num
856: --
857: , SUM(NVL(mtln.transaction_quantity, rt.quantity)) quantity
858: , SUM(NVL(mtln.SECONDARY_TRANSACTION_QUANTITY, rt.SECONDARY_QUANTITY)) secondary_quantity -- fabdi 4373856
859: , (inv_label_pvt1.get_uom_code(
860: rt.organization_id
861: , rsl.item_id
862: , rsl.unit_of_measure
863: )

Line 865: , (inv_label_pvt1.get_uom2_code(

861: , rsl.item_id
862: , rsl.unit_of_measure
863: )
864: ) uom
865: , (inv_label_pvt1.get_uom2_code(
866: rt.organization_id
867: , rsl.item_id
868: )
869: ) secondary_uom -- bug 4373856

Line 978: , (inv_label_pvt1.get_uom_code(

974: --, pod.task_id --Commented as part of Bug# 3586116
975: -- Added by joabraha bug 3472150
976: , rsh.receipt_num
977: --
978: , (inv_label_pvt1.get_uom_code(
979: rt.organization_id
980: , rsl.item_id
981: , rsl.unit_of_measure
982: )

Line 984: , (inv_label_pvt1.get_uom2_code(

980: , rsl.item_id
981: , rsl.unit_of_measure
982: )
983: )
984: , (inv_label_pvt1.get_uom2_code(
985: rt.organization_id
986: , rsl.item_id
987: )
988: ) -- bug 4373856

Line 1043: , (inv_label_pvt1.get_uom_code(

1039: , rsh.receipt_num
1040: --
1041: , SUM(NVL(mtln.transaction_quantity, rt.quantity)) quantity
1042: , SUM(NVL(mtln.SECONDARY_TRANSACTION_QUANTITY, rt.SECONDARY_QUANTITY)) secondary_quantity
1043: , (inv_label_pvt1.get_uom_code(
1044: rt.organization_id
1045: , rsl.item_id
1046: , rsl.unit_of_measure
1047: )

Line 1049: , (inv_label_pvt1.get_uom2_code(

1045: , rsl.item_id
1046: , rsl.unit_of_measure
1047: )
1048: ) uom
1049: , (inv_label_pvt1.get_uom2_code(
1050: rt.organization_id
1051: , rsl.item_id
1052: )
1053: ) secondary_uom -- bug 4373856

Line 1154: , (inv_label_pvt1.get_uom_code(

1150: --, pod.task_id --Commented as part of Bug# 3586116
1151: -- Added by joabraha bug 3472150
1152: , rsh.receipt_num
1153: --
1154: , (inv_label_pvt1.get_uom_code(
1155: rt.organization_id
1156: , rsl.item_id
1157: , rsl.unit_of_measure
1158: )

Line 1160: , (inv_label_pvt1.get_uom2_code(

1156: , rsl.item_id
1157: , rsl.unit_of_measure
1158: )
1159: )
1160: , (inv_label_pvt1.get_uom2_code(
1161: rt.organization_id
1162: , rsl.item_id
1163: )
1164: ) -- bug 4373856

Line 6116: END inv_label_pvt1;

6112:
6113: RETURN l_return_flag;
6114: END IF;
6115: END;
6116: END inv_label_pvt1;