APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PO_LINE_TYPES_B

Line 2733: PO_LINE_TYPES_B PLTB

2729: Nvl(CLM_INFO_FLAG,'N') sel_is_info_line,
2730: PAIP.line_num_display sel_clm_line_num_display
2731: FROM
2732: PON_AUCTION_ITEM_PRICES_ALL PAIP,
2733: PO_LINE_TYPES_B PLTB
2734: WHERE
2735: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
2736: PLTB.LINE_TYPE_ID = PAIP.LINE_TYPE_ID;
2737:

Line 2797: PO_LINE_TYPES_B PLTB

2793: sysdate, -- LAST_UPDATE_DATE
2794: p_login_id -- LAST_UPDATE_LOGIN
2795: FROM
2796: PON_AUCTION_ITEM_PRICES_ALL PAIP,
2797: PO_LINE_TYPES_B PLTB
2798: WHERE
2799: AUCTION_HEADER_ID = p_auction_header_id AND
2800: PAIP.LINE_TYPE_ID = PLTB.LINE_TYPE_ID AND
2801: NVL (PAIP.GROUP_TYPE, g_invalid_string) <> 'GROUP' AND

Line 5163: FROM PO_LINE_TYPES_B

5159: (
5160: SELECTED_LINE_ORIGINATION_CODE = 'BLANKET' AND
5161: sel_clm_info_flag <> 'Y' AND -- Clin Slin Changes
5162: NOT EXISTS (SELECT 'X'
5163: FROM PO_LINE_TYPES_B
5164: WHERE LINE_TYPE_ID = SELECTED_LINE_TYPE_ID)
5165: )
5166: THEN INTO PON_INTERFACE_ERRORS
5167: (

Line 5287: FROM PO_LINE_TYPES_B PLT

5283: NVL(FSP.ORG_ID, -9999) = NVL(SELECTED_ORG_ID, -9999) AND
5284: (MSI.OUTSIDE_OPERATION_FLAG <> 'Y'
5285: OR (MSI.OUTSIDE_OPERATION_FLAG = 'Y'
5286: AND EXISTS (SELECT 'OP LINE TYPE'
5287: FROM PO_LINE_TYPES_B PLT
5288: WHERE PLT.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID
5289: AND PLT.OUTSIDE_OPERATION_FLAG ='Y') ) ) )
5290: )
5291: THEN INTO PON_INTERFACE_ERRORS

Line 5390: PO_LINE_TYPES_B PLTB

5386: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
5387: MTL_SYSTEM_ITEMS MSI,
5388: MTL_ITEM_REVISIONS MIR,
5389: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
5390: PO_LINE_TYPES_B PLTB
5391: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
5392: FSP.ORG_ID = SELECTED_ORG_ID AND
5393: PLTB.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID AND
5394: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) AND

Line 5510: PO_LINE_TYPES_B PLTB

5506: (SELECT OOD.ORGANIZATION_ID
5507: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
5508: MTL_SYSTEM_ITEMS_KFV MSI,
5509: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
5510: PO_LINE_TYPES_B PLTB
5511: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
5512: FSP.ORG_ID = SELECTED_ORG_ID AND
5513: PLTB.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID AND
5514: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) AND

Line 5670: PO_LINE_TYPES_B PLTB,

5666: p_user_id, -- LAST_UPDATED_BY
5667: sysdate, -- LAST_UPDATE_DATE
5668: p_login_id -- LAST_UPDATE_LOGIN
5669: FROM
5670: PO_LINE_TYPES_B PLTB,
5671: PON_AUCTION_ITEM_PRICES_ALL PAIP
5672: WHERE
5673: PAIP.AUCTION_HEADER_ID=p_auction_header_id AND
5674: PLTB.LINE_TYPE_ID= PAIP.LINE_TYPE_ID AND

Line 7384: -- po_line_types_b

7380: message => 'Validating Lines: Validations that do not require join with po line types');
7381: END IF; --}
7382:
7383: -- Validations that are done in this procedure do not require a join with
7384: -- po_line_types_b
7385: val_item_prices_all (
7386: p_auction_header_id, p_request_id, l_expiration_date, l_user_id,
7387: l_login_id, l_batch_id, p_auction_currency_precision,
7388: p_fnd_currency_precision, p_close_bidding_date, p_contract_type,

Line 7401: -- po_line_types_b

7397:
7398: val_exhibits(p_auction_header_id,p_request_id,l_batch_id,l_expiration_date,l_user_id,l_login_id);
7399:
7400: -- Validations that are done in this procedure require a join with
7401: -- po_line_types_b
7402: val_item_prices_po_lines (
7403: p_auction_header_id, p_request_id, l_expiration_date, l_user_id,
7404: l_login_id, l_batch_id, p_doctype_id, p_contract_type, p_global_agreement_flag,
7405: p_auction_currency_precision, p_fnd_currency_precision);