APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PO_LINE_TYPES

Line 704: po_line_types_tl pltt

700: , ai.document_disp_line_number
701: FROM PON_AWARD_ITEMS_INTERFACE paii,
702: pon_auction_item_prices_all ai,
703: pon_auction_headers_all ah,
704: po_line_types_tl pltt
705: WHERE paii.batch_id = p_batch_id
706: AND paii.award_status = 'Y'
707: AND ah.auction_header_id = paii.auction_header_id
708: AND ah.contract_type = 'STANDARD'

Line 792: PO_LINE_TYPES plt

788: plt.outside_operation_flag po_outside_operation_flag,
789: plt.line_type_id,
790: plt.line_type
791: FROM PON_ITEM_PRICES_INTERFACE pipi,
792: PO_LINE_TYPES plt
793: WHERE batch_id = p_batch_id
794: AND pipi.line_type_id = plt.line_type_id (+)
795: AND pipi.group_type NOT IN ('GROUP','LOT_LINE');
796:

Line 1258: PO_LINE_TYPES plt

1254: plt.line_type
1255: FROM PON_ITEM_PRICES_INTERFACE pipi,
1256: PA_PROJECTS_EXPEND_V pro,
1257: PA_ORGANIZATIONS_EXPEND_V porg,
1258: PO_LINE_TYPES plt
1259: WHERE batch_id = p_batch_id
1260: AND pipi.project_number = pro.project_number (+)
1261: AND pipi.project_exp_organization_name = porg.name(+)
1262: AND pipi.line_type_id = plt.line_type_id (+)

Line 1622: FROM po_line_types_vl po2 WHERE upper(p1.line_type) = upper(po2.line_type(+))

1618:
1619: update pon_item_prices_interface p1
1620: set (line_type_id,order_type_lookup_code,purchase_basis,outside_operation_flag) =
1621: (select nvl(po2.line_type_id,-9999), po2.order_type_lookup_code,po2.purchase_basis,po2.outside_operation_flag
1622: FROM po_line_types_vl po2 WHERE upper(p1.line_type) = upper(po2.line_type(+))
1623: and (po2.inactive_date is null or po2.inactive_date > sysdate))
1624: where batch_id = p_batch_id
1625: and line_type <> 'LINE_TYPE_NONE_ENTERED'
1626: and line_type is not null;

Line 2147: ,PO_LINE_TYPES plt

2143: update pon_item_prices_interface p1
2144: set CATEGORY_NAME = (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2145: from
2146: MTL_CATEGORIES_KFV mck
2147: ,PO_LINE_TYPES plt
2148: where
2149: plt.line_type_id = p1.line_type_id
2150: and plt.category_id = mck.category_id)
2151: where batch_id = p_batch_id

Line 2163: PO_LINE_TYPES plt

2159:
2160: update pon_item_prices_interface p1
2161: set UNIT_OF_MEASURE = (select plt.unit_of_measure
2162: from
2163: PO_LINE_TYPES plt
2164: where
2165: plt.line_type_id = p1.line_type_id)
2166: where batch_id = p_batch_id
2167: and ((UNIT_OF_MEASURE = 'UOM_NONE_ENTERED') or (UNIT_OF_MEASURE is null));