APPS.PO_UOM_S dependencies on MTL_SYSTEM_ITEMS

Line 6: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE

2: /* $Header: RCVTXU1B.pls 120.3.12010000.2 2008/08/04 08:43:30 rramasam 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 534: ** from mtl_system_items

530: else
531:
532: /*
533: ** for pre-defined items, get the primary uom
534: ** from mtl_system_items
535: */
536:
537: begin
538:

Line 541: from mtl_system_items msi

537: begin
538:
539: select msi.primary_unit_of_measure
540: into primary_unit
541: from mtl_system_items msi
542: where msi.inventory_item_id = item_id
543: and msi.organization_id = org_id;
544:
545: exception

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

865: x_secondary_unit_of_measure out NOCOPY varchar2) is
866:
867: msgbuf varchar2(200);
868: x_progress varchar2(3) := NULL;
869: l_tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE:= NULL;
870:
871: begin
872: msgbuf := '';
873: x_progress := '001';

Line 879: from mtl_system_items msi, mtl_units_of_measure muom

875: if (p_item_id is not null) then
876: begin
877: select msi.tracking_quantity_ind,msi.secondary_uom_code, muom.unit_of_measure
878: into l_tracking_quantity_ind, x_secondary_uom_code,x_secondary_unit_of_measure
879: from mtl_system_items msi, mtl_units_of_measure muom
880: where msi.inventory_item_id = p_item_id
881: and msi.organization_id = p_org_id
882: and msi.secondary_uom_code = muom.uom_code(+);
883: