DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on PO_LINES_ALL

Line 1872: PO_LINES_ALL PL,

1868: )),0)
1869: INTO x_result_fld
1870: FROM PO_DISTRIBUTIONS_ALL POD,
1871: PO_LINE_LOCATIONS_ALL PLL,
1872: PO_LINES_ALL PL,
1873: PO_HEADERS_ALL PH,
1874: PO_HEADERS_ALL PH1
1875: --,FND_CURRENCIES C
1876: WHERE PH.po_header_id = x_object_id

Line 1906: PO_LINES_ALL PL,

1902: * x_min_unit),0)
1903: INTO x_result_fld
1904: FROM PO_DISTRIBUTIONS_ALL POD,
1905: PO_LINE_LOCATIONS_ALL PLL,
1906: PO_LINES_ALL PL,
1907: PO_HEADERS_ALL PH,
1908: PO_HEADERS_ALL PH1
1909: --,FND_CURRENCIES C
1910: WHERE PH.po_header_id = x_object_id

Line 2135: PO_LINES_ALL POL

2131: INTO x_min_unit,
2132: x_precision
2133: FROM FND_CURRENCIES C,
2134: PO_HEADERS_ALL PH,
2135: PO_LINES_ALL POL
2136: WHERE POL.po_line_id = x_object_id
2137: AND PH.po_header_id = POL.po_header_id
2138: AND C.currency_code = PH.CURRENCY_CODE;
2139:

Line 2565: PO_LINES_ALL POL

2561: INTO l_min_unit,
2562: l_precision
2563: FROM FND_CURRENCIES C,
2564: PO_HEADERS_ALL PH,
2565: PO_LINES_ALL POL
2566: WHERE POL.po_line_id = p_object_id
2567: AND PH.po_header_id = POL.po_header_id
2568: AND C.currency_code = PH.CURRENCY_CODE;
2569:

Line 2884: p_line_id IN PO_LINES_ALL.PO_LINE_ID%TYPE ,

2880:
2881: ===================================================================================*/
2882: FUNCTION GET_RELEASE_LINE_TOTAL
2883: (
2884: p_line_id IN PO_LINES_ALL.PO_LINE_ID%TYPE ,
2885: p_release_id IN PO_RELEASES_ALL.PO_RELEASE_ID%TYPE
2886: )
2887: RETURN NUMBER
2888: IS

Line 2901: PO_LINES_ALL POL

2897: INTO x_min_unit,
2898: x_precision
2899: FROM FND_CURRENCIES C,
2900: PO_HEADERS_ALL PH,
2901: PO_LINES_ALL POL
2902: WHERE POL.po_line_id = p_line_id
2903: AND PH.po_header_id = POL.po_header_id
2904: AND C.currency_code = PH.CURRENCY_CODE;
2905:

Line 3039: po_lines_all pol

3035: * l_base_min_unit )
3036: INTO x_total
3037: FROM po_distributions_all pod,
3038: po_line_locations_all poll,
3039: po_lines_all pol
3040: WHERE pod.line_location_id = poll.line_location_id
3041: AND poll.po_line_id = pol.po_line_id
3042: AND pol.from_header_id = p_po_header_id;
3043:

Line 3064: po_lines_all pol

3060: * l_base_min_unit )
3061: INTO x_total
3062: FROM po_distributions_all pod,
3063: po_line_locations_all poll,
3064: po_lines_all pol
3065: WHERE pod.line_location_id = poll.line_location_id
3066: AND poll.po_line_id = pol.po_line_id
3067: AND pol.from_header_id = p_po_header_id;
3068:

Line 3093: po_lines_all pol

3089: * l_po_min_unit )
3090: INTO x_total
3091: FROM po_distributions_all pod,
3092: po_line_locations_all poll,
3093: po_lines_all pol
3094: WHERE pod.line_location_id = poll.line_location_id
3095: AND poll.po_line_id = pol.po_line_id
3096: AND pol.from_header_id = p_po_header_id;
3097:

Line 3116: po_lines_all pol

3112: * l_rate )
3113: INTO x_total
3114: FROM po_distributions_all pod,
3115: po_line_locations_all poll,
3116: po_lines_all pol
3117: WHERE pod.line_location_id = poll.line_location_id
3118: AND poll.po_line_id = pol.po_line_id
3119: AND pol.from_header_id = p_po_header_id;
3120:

Line 3146: po_lines_all pol

3142: * l_po_min_unit )
3143: INTO x_total
3144: FROM po_distributions_all pod,
3145: po_line_locations_all poll,
3146: po_lines_all pol
3147: WHERE pod.line_location_id = poll.line_location_id
3148: AND poll.po_line_id = pol.po_line_id
3149: AND pol.from_header_id = p_po_header_id;
3150:

Line 3168: po_lines_all pol

3164: )
3165: INTO x_total
3166: FROM po_distributions_all pod,
3167: po_line_locations_all poll,
3168: po_lines_all pol
3169: WHERE pod.line_location_id = poll.line_location_id
3170: AND poll.po_line_id = pol.po_line_id
3171: AND pol.from_header_id = p_po_header_id;
3172:

Line 3197: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,

3193:
3194: ===================================================================================*/
3195: PROCEDURE get_ga_line_amount_released
3196: (
3197: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
3198: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
3199: x_quantity_released OUT NOCOPY NUMBER,
3200: x_amount_released OUT NOCOPY NUMBER
3201: )

Line 3246: po_lines_all pol

3242: INTO x_amount_released,
3243: x_quantity_released
3244: FROM po_distributions_all pod,
3245: po_line_locations_all poll,
3246: po_lines_all pol
3247: WHERE pod.line_location_id = poll.line_location_id
3248: AND poll.po_line_id = pol.po_line_id
3249: AND pol.from_line_id = p_po_line_id;
3250:

Line 3270: po_lines_all pol

3266: INTO x_amount_released,
3267: x_quantity_released
3268: FROM po_distributions_all pod,
3269: po_line_locations_all poll,
3270: po_lines_all pol
3271: WHERE pod.line_location_id = poll.line_location_id
3272: AND poll.po_line_id = pol.po_line_id
3273: AND pol.from_line_id = p_po_line_id;
3274:

Line 3408: PO_LINES_ALL POL,

3404: ,0)
3405: INTO l_total
3406: FROM PO_DISTRIBUTIONS_ALL POD,
3407: PO_LINE_LOCATIONS_ALL POLL,
3408: PO_LINES_ALL POL,
3409: PO_HEADERS_ALL PH1
3410: WHERE POL.contract_id = p_po_header_id
3411: AND POL.po_line_id = POLL.po_line_id
3412: AND POLL.shipment_type in ('STANDARD','PLANNED')

Line 3474: PO_LINES_ALL POL,

3470: ,0)
3471: INTO l_total
3472: FROM PO_DISTRIBUTIONS_ALL POD,
3473: PO_LINE_LOCATIONS_ALL POLL,
3474: PO_LINES_ALL POL,
3475: PO_HEADERS_ALL PH1
3476: WHERE POL.contract_id = p_po_header_id
3477: AND POL.po_line_id = POLL.po_line_id
3478: AND POLL.shipment_type in ('STANDARD','PLANNED')

Line 3541: PO_LINES_ALL PoL,

3537: ),0)
3538: INTO l_total
3539: FROM PO_DISTRIBUTIONS_ALL POD,
3540: PO_LINE_LOCATIONS_ALL POLL,
3541: PO_LINES_ALL PoL,
3542: PO_HEADERS_ALL PH1
3543: WHERE POL.contract_id = p_po_header_id
3544: AND POL.po_line_id = POLL.po_line_id
3545: AND POLL.shipment_type in ('STANDARD','PLANNED')

Line 3604: PO_LINES_ALL POL,

3600: ),0)
3601: INTO l_total
3602: FROM PO_DISTRIBUTIONS_ALL POD,
3603: PO_LINE_LOCATIONS_ALL POLL,
3604: PO_LINES_ALL POL,
3605: PO_HEADERS_ALL PH1
3606: WHERE POL.contract_id = p_po_header_id
3607: AND POL.po_line_id = POLL.po_line_id
3608: AND POLL.shipment_type in ('STANDARD','PLANNED')

Line 3672: PO_LINES_ALL POL,

3668: ,0)
3669: INTO l_total
3670: FROM PO_DISTRIBUTIONS_ALL POD,
3671: PO_LINE_LOCATIONS_ALL POLL,
3672: PO_LINES_ALL POL,
3673: PO_HEADERS_ALL PH,
3674: PO_HEADERS_ALL PH1
3675: WHERE PH.po_header_id = p_po_header_id
3676: AND PH.po_header_id = POL.contract_id

Line 3739: PO_LINES_ALL POL,

3735: ,0)
3736: INTO l_total
3737: FROM PO_DISTRIBUTIONS_ALL POD,
3738: PO_LINE_LOCATIONS_ALL POLL,
3739: PO_LINES_ALL POL,
3740: PO_HEADERS_ALL PH,
3741: PO_HEADERS_ALL PH1
3742: WHERE PH.po_header_id = p_po_header_id
3743: AND PH.po_header_id = POL.contract_id --

Line 4083: FROM PO_LINES_ALL POL

4079: UPDATE PO_SESSION_GT
4080: SET num2 =
4081: (
4082: SELECT POL.po_header_id
4083: FROM PO_LINES_ALL POL
4084: WHERE POL.po_line_id = p_doc_level_id_tbl(i)
4085: )
4086: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
4087: RETURNING num2

Line 4338: PO_LINES_ALL POL

4334:
4335: SELECT POL.po_line_id
4336: BULK COLLECT INTO x_line_id_tbl
4337: FROM
4338: PO_LINES_ALL POL
4339: , PO_SESSION_GT IDS
4340: WHERE POL.po_header_id = IDS.num1
4341: AND IDS.key = l_id_key
4342: ;

Line 7826: line_last_update_date PO_LINES_ALL.last_update_date%type;

7822: -------------------------------------------------------------------------------
7823: FUNCTION get_last_update_date_for_doc(p_doc_header_id IN NUMBER) RETURN DATE
7824: IS
7825: header_last_update_date PO_HEADERS_ALL.last_update_date%type;
7826: line_last_update_date PO_LINES_ALL.last_update_date%type;
7827: line_loc_last_update_date PO_LINE_LOCATIONS_ALL.last_update_date%type;
7828: dist_last_update_date PO_DISTRIBUTIONS_ALL.last_update_date%type;
7829: doc_last_update_date PO_HEADERS_ALL.last_update_date%type;
7830: --Lowest date supported by database as we need to handle null dates

Line 7844: select nvl(max(last_update_date), min_date) into line_last_update_date from po_lines_all where po_header_id = p_doc_header_id;

7840: END IF;
7841: d_pos := 10;
7842: select nvl(max(last_update_date), min_date) into header_last_update_date from po_headers_all where po_header_id = p_doc_header_id;
7843: d_pos := 20;
7844: select nvl(max(last_update_date), min_date) into line_last_update_date from po_lines_all where po_header_id = p_doc_header_id;
7845: d_pos := 30;
7846: select nvl(max(last_update_date), min_date) into line_loc_last_update_date from po_line_locations_all where po_header_id = p_doc_header_id;
7847: d_pos := 40;
7848: select nvl(max(last_update_date), min_date) into dist_last_update_date from po_distributions_all where po_header_id = p_doc_header_id;