eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_INTERFACE_S2 dependencies on STANDARD

Line 292: -- documents type referenced on this standard PO

288:
289: --
290:
291: -- SQL What: Get the number of distinct source documents for each source
292: -- documents type referenced on this standard PO
293: -- SQL Why: Based on the terms default hierarchy, we want to default the
294: -- terms and conditions from the source document if there is only
295: -- one distinct document of that document type.
296:

Line 341: -- referenced on the standard PO lines, default terms and conditions

337: -- Rules of defaulting terms and conditions:
338: -- The source document hieararchy for terms and conditions defaulting is:
339: -- Global Agreement, Quotation, Local Contract, Global Contract.
340: -- 1) For a src document type, if there is only one distinct documents
341: -- referenced on the standard PO lines, default terms and conditions
342: -- from that src document
343: -- 2) If there are more than one distinct documents on that type being
344: -- referenced on the standard PO, do not default terms and conditions
345: -- 3) If there is no document of this type being referenced on the standard

Line 344: -- referenced on the standard PO, do not default terms and conditions

340: -- 1) For a src document type, if there is only one distinct documents
341: -- referenced on the standard PO lines, default terms and conditions
342: -- from that src document
343: -- 2) If there are more than one distinct documents on that type being
344: -- referenced on the standard PO, do not default terms and conditions
345: -- 3) If there is no document of this type being referenced on the standard
346: -- PO, get the next document type and repeat the same checking.
347:
348: IF (l_ga_count > 0) THEN

Line 345: -- 3) If there is no document of this type being referenced on the standard

341: -- referenced on the standard PO lines, default terms and conditions
342: -- from that src document
343: -- 2) If there are more than one distinct documents on that type being
344: -- referenced on the standard PO, do not default terms and conditions
345: -- 3) If there is no document of this type being referenced on the standard
346: -- PO, get the next document type and repeat the same checking.
347:
348: IF (l_ga_count > 0) THEN
349: IF (l_ga_count = 1) THEN

Line 512: * Effects: Get the distinct source document on the standard PO, given

508: --
509:
510: /**=========================================================================
511: * Procedure: get_distinct_src_id
512: * Effects: Get the distinct source document on the standard PO, given
513: * the the source document type.
514: * Requires: The proceudre assumes that there is only one distinct reference
515: * document of the type specified within the whole standard PO.
516: * Parameters: p_po_header_id - header id of the standard PO

Line 515: * document of the type specified within the whole standard PO.

511: * Procedure: get_distinct_src_id
512: * Effects: Get the distinct source document on the standard PO, given
513: * the the source document type.
514: * Requires: The proceudre assumes that there is only one distinct reference
515: * document of the type specified within the whole standard PO.
516: * Parameters: p_po_header_id - header id of the standard PO
517: * p_src_doc_type - src document type being searched for
518: * p_global_flag - whether the src document is global
519: * x_src_doc_id - return value (header id of the src document)

Line 516: * Parameters: p_po_header_id - header id of the standard PO

512: * Effects: Get the distinct source document on the standard PO, given
513: * the the source document type.
514: * Requires: The proceudre assumes that there is only one distinct reference
515: * document of the type specified within the whole standard PO.
516: * Parameters: p_po_header_id - header id of the standard PO
517: * p_src_doc_type - src document type being searched for
518: * p_global_flag - whether the src document is global
519: * x_src_doc_id - return value (header id of the src document)
520: ==========================================================================**/