APPS.POS_ASN_CREATE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 612: mtl_system_items msi,

608: l_revision,
609: l_val_mode
610: from
611: po_lines_all pla,
612: mtl_system_items msi,
613: po_line_locations_all plla
614: where pla.item_id = msi.inventory_item_id
615: and plla.ship_to_organization_id = msi.organization_id
616: and plla.line_location_id = p_line_loc_id

Line 896: l_lot_code mtl_system_items.lot_control_code%type;

892: procedure findLlsCode(p_line_location_id in number, x_llsCode out nocopy varchar2)
893: IS
894: l_api_name varchar2(50) := 'findLlsCode';
895: l_progress varchar2(20) := '000';
896: l_lot_code mtl_system_items.lot_control_code%type;
897: l_serial_code mtl_system_items.serial_number_control_code%type;
898: l_item_id number;
899: l_org_id po_line_locations_all.ship_to_organization_id%type;
900: BEGIN

Line 897: l_serial_code mtl_system_items.serial_number_control_code%type;

893: IS
894: l_api_name varchar2(50) := 'findLlsCode';
895: l_progress varchar2(20) := '000';
896: l_lot_code mtl_system_items.lot_control_code%type;
897: l_serial_code mtl_system_items.serial_number_control_code%type;
898: l_item_id number;
899: l_org_id po_line_locations_all.ship_to_organization_id%type;
900: BEGIN
901: l_progress := '001'||p_line_location_id;

Line 923: mtl_system_items msi

919: into
920: l_lot_code,
921: l_serial_code
922: from
923: mtl_system_items msi
924: where msi.inventory_item_id=l_item_id
925: and msi.organization_id=l_org_id;
926:
927: