APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PO_LINE_TYPES_B

Line 1898: PO_LINE_TYPES_B PLTB

1894: PAIP.UNIT_TARGET_PRICE sel_unit_target_price,
1895: PAIP.QUANTITY sel_quantity
1896: FROM
1897: PON_AUCTION_ITEM_PRICES_ALL PAIP,
1898: PO_LINE_TYPES_B PLTB
1899: WHERE
1900: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
1901: PLTB.LINE_TYPE_ID = PAIP.LINE_TYPE_ID;
1902:

Line 1962: PO_LINE_TYPES_B PLTB

1958: sysdate, -- LAST_UPDATE_DATE
1959: p_login_id -- LAST_UPDATE_LOGIN
1960: FROM
1961: PON_AUCTION_ITEM_PRICES_ALL PAIP,
1962: PO_LINE_TYPES_B PLTB
1963: WHERE
1964: AUCTION_HEADER_ID = p_auction_header_id AND
1965: PAIP.LINE_TYPE_ID = PLTB.LINE_TYPE_ID AND
1966: NVL (PAIP.GROUP_TYPE, g_invalid_string) <> 'GROUP' AND

Line 4317: FROM PO_LINE_TYPES_B

4313: WHEN
4314: (
4315: SELECTED_LINE_ORIGINATION_CODE = 'BLANKET' AND
4316: NOT EXISTS (SELECT 'X'
4317: FROM PO_LINE_TYPES_B
4318: WHERE LINE_TYPE_ID = SELECTED_LINE_TYPE_ID)
4319: )
4320: THEN INTO PON_INTERFACE_ERRORS
4321: (

Line 4441: FROM PO_LINE_TYPES_B PLT

4437: NVL(FSP.ORG_ID, -9999) = NVL(SELECTED_ORG_ID, -9999) AND
4438: (MSI.OUTSIDE_OPERATION_FLAG <> 'Y'
4439: OR (MSI.OUTSIDE_OPERATION_FLAG = 'Y'
4440: AND EXISTS (SELECT 'OP LINE TYPE'
4441: FROM PO_LINE_TYPES_B PLT
4442: WHERE PLT.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID
4443: AND PLT.OUTSIDE_OPERATION_FLAG ='Y') ) ) )
4444: )
4445: THEN INTO PON_INTERFACE_ERRORS

Line 4541: PO_LINE_TYPES_B PLTB

4537: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
4538: MTL_SYSTEM_ITEMS MSI,
4539: MTL_ITEM_REVISIONS MIR,
4540: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
4541: PO_LINE_TYPES_B PLTB
4542: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
4543: FSP.ORG_ID = SELECTED_ORG_ID AND
4544: PLTB.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID AND
4545: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) AND

Line 4660: PO_LINE_TYPES_B PLTB

4656: (SELECT OOD.ORGANIZATION_ID
4657: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
4658: MTL_SYSTEM_ITEMS_KFV MSI,
4659: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
4660: PO_LINE_TYPES_B PLTB
4661: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
4662: FSP.ORG_ID = SELECTED_ORG_ID AND
4663: PLTB.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID AND
4664: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) AND

Line 4819: PO_LINE_TYPES_B PLTB,

4815: p_user_id, -- LAST_UPDATED_BY
4816: sysdate, -- LAST_UPDATE_DATE
4817: p_login_id -- LAST_UPDATE_LOGIN
4818: FROM
4819: PO_LINE_TYPES_B PLTB,
4820: PON_AUCTION_ITEM_PRICES_ALL PAIP
4821: WHERE
4822: PAIP.AUCTION_HEADER_ID=p_auction_header_id AND
4823: PLTB.LINE_TYPE_ID= PAIP.LINE_TYPE_ID AND

Line 6495: -- po_line_types_b

6491: message => 'Validating Lines: Validations that do not require join with po line types');
6492: END IF; --}
6493:
6494: -- Validations that are done in this procedure do not require a join with
6495: -- po_line_types_b
6496: val_item_prices_all (
6497: p_auction_header_id, p_request_id, l_expiration_date, l_user_id,
6498: l_login_id, l_batch_id, p_auction_currency_precision,
6499: p_fnd_currency_precision, p_close_bidding_date, p_contract_type,

Line 6510: -- po_line_types_b

6506: message => 'Validating Lines: Validations that require join with po line types');
6507: END IF; --}
6508:
6509: -- Validations that are done in this procedure require a join with
6510: -- po_line_types_b
6511: val_item_prices_po_lines (
6512: p_auction_header_id, p_request_id, l_expiration_date, l_user_id,
6513: l_login_id, l_batch_id, p_doctype_id, p_contract_type, p_global_agreement_flag,
6514: p_auction_currency_precision, p_fnd_currency_precision);