APPS.PO_UOM_S dependencies on MTL_SYSTEM_ITEMS

Line 6: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE

2: /* $Header: RCVTXU1B.pls 120.9.12020000.9 2013/05/03 10:39:14 bpulivar ship $*/
3:
4: --
5: g_chktype_TRACKING_QTY_IND_S CONSTANT
6: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE
7: := 'PS';
8:
9: /*============================== PO_UOM_S ================================*/
10:

Line 612: ** from mtl_system_items

608: else
609:
610: /*
611: ** for pre-defined items, get the primary uom
612: ** from mtl_system_items
613: */
614:
615: begin
616:

Line 619: from mtl_system_items msi

615: begin
616:
617: select msi.primary_unit_of_measure
618: into primary_unit
619: from mtl_system_items msi
620: where msi.inventory_item_id = item_id
621: and msi.organization_id = org_id;
622:
623: exception

Line 947: l_tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE:= NULL;

943: x_secondary_unit_of_measure out NOCOPY varchar2) is
944:
945: msgbuf varchar2(200);
946: x_progress varchar2(3) := NULL;
947: l_tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE:= NULL;
948:
949: begin
950: msgbuf := '';
951: x_progress := '001';

Line 957: from mtl_system_items msi, mtl_units_of_measure muom

953: if (p_item_id is not null) then
954: begin
955: select msi.tracking_quantity_ind,msi.secondary_uom_code, muom.unit_of_measure
956: into l_tracking_quantity_ind, x_secondary_uom_code,x_secondary_unit_of_measure
957: from mtl_system_items msi, mtl_units_of_measure muom
958: where msi.inventory_item_id = p_item_id
959: and msi.organization_id = p_org_id
960: and msi.secondary_uom_code = muom.uom_code(+);
961: