APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PO_LINE_TYPES

Line 728: po_line_types_tl pltt

724: , ai.document_disp_line_number
725: FROM PON_AWARD_ITEMS_INTERFACE paii,
726: pon_auction_item_prices_all ai,
727: pon_auction_headers_all ah,
728: po_line_types_tl pltt
729: WHERE paii.batch_id = p_batch_id
730: AND paii.award_status = 'Y'
731: AND ah.auction_header_id = paii.auction_header_id
732: AND ah.contract_type = 'STANDARD'

Line 824: PO_LINE_TYPES plt

820: plt.outside_operation_flag po_outside_operation_flag,
821: plt.line_type_id,
822: plt.line_type
823: FROM PON_ITEM_PRICES_INTERFACE pipi,
824: PO_LINE_TYPES plt
825: WHERE batch_id = p_batch_id
826: AND pipi.line_type_id = plt.line_type_id (+)
827: AND pipi.group_type NOT IN ('GROUP','LOT_LINE');
828:

Line 1309: PO_LINE_TYPES plt

1305: Nvl(pipi.CLM_INFO_FLAG, 'N') S_CLM_INFO_FLAG
1306: FROM PON_ITEM_PRICES_INTERFACE pipi,
1307: PA_PROJECTS_EXPEND_V pro,
1308: PA_ORGANIZATIONS_EXPEND_V porg,
1309: PO_LINE_TYPES plt
1310: WHERE batch_id = p_batch_id
1311: AND pipi.project_number = pro.project_number (+)
1312: AND pipi.project_exp_organization_name = porg.name(+)
1313: AND pipi.line_type_id = plt.line_type_id (+)

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

1805:
1806: update pon_item_prices_interface p1
1807: set (line_type_id,order_type_lookup_code,purchase_basis,outside_operation_flag) =
1808: (select nvl(po2.line_type_id,-9999), po2.order_type_lookup_code,po2.purchase_basis,po2.outside_operation_flag
1809: FROM po_line_types_vl po2 WHERE upper(p1.line_type) = upper(po2.line_type(+))
1810: and (po2.inactive_date is null or po2.inactive_date > sysdate))
1811: where batch_id = p_batch_id
1812: and line_type <> 'LINE_TYPE_NONE_ENTERED'
1813: AND Nvl(clm_info_flag,'N') <> 'Y'

Line 2343: ,PO_LINE_TYPES plt

2339: update pon_item_prices_interface p1
2340: set CATEGORY_NAME = (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2341: from
2342: MTL_CATEGORIES_KFV mck
2343: ,PO_LINE_TYPES plt
2344: where
2345: plt.line_type_id = p1.line_type_id
2346: and plt.category_id = mck.category_id)
2347: where batch_id = p_batch_id

Line 2360: PO_LINE_TYPES plt

2356:
2357: update pon_item_prices_interface p1
2358: set UNIT_OF_MEASURE = (select plt.unit_of_measure
2359: from
2360: PO_LINE_TYPES plt
2361: where
2362: plt.line_type_id = p1.line_type_id)
2363: where batch_id = p_batch_id
2364: and ((UNIT_OF_MEASURE = 'UOM_NONE_ENTERED') or (UNIT_OF_MEASURE is null))

Line 3631: AND P1.LINE_TYPE_ID NOT IN (SELECT LINE_TYPE_ID FROM po_line_types_b WHERE ORDER_TYPE_LOOKUP_CODE = 'AMOUNT')

3627: interface_line_id
3628: from pon_item_prices_interface P1
3629: where batch_id = p_batch_id
3630: AND P1.CLM_AMOUNT IS NOT NULL
3631: AND P1.LINE_TYPE_ID NOT IN (SELECT LINE_TYPE_ID FROM po_line_types_b WHERE ORDER_TYPE_LOOKUP_CODE = 'AMOUNT')
3632: );
3633:
3634: /* CLM_UNIT_PRICE */
3635: insert into PON_INTERFACE_ERRORS

Line 3653: AND P1.LINE_TYPE_ID NOT IN (SELECT LINE_TYPE_ID FROM po_line_types_b WHERE ORDER_TYPE_LOOKUP_CODE = 'QUANTITY')

3649: interface_line_id
3650: from pon_item_prices_interface P1
3651: where batch_id = p_batch_id
3652: AND P1.CLM_UNIT_PRICE IS NOT NULL
3653: AND P1.LINE_TYPE_ID NOT IN (SELECT LINE_TYPE_ID FROM po_line_types_b WHERE ORDER_TYPE_LOOKUP_CODE = 'QUANTITY')
3654: );
3655:
3656:
3657: /* CLM_CONTRACT_TYPE*/