DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 2662: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

2658: AND si.inventory_item_id = pol.item_id
2659: AND si.comms_nl_trackable_flag = 'Y'
2660: AND (si.organization_id = pod.org_id
2661: OR /* Added for bug 13714500 */
2662: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
2663: where pll.po_header_id = pod.po_header_id
2664: and pll.po_line_id = pod.po_line_id)
2665: )
2666: )

Line 2681: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

2677: and si.inventory_item_id = pol.item_id
2678: AND si.comms_nl_trackable_flag = 'Y'
2679: AND (si.organization_id = pod.org_id
2680: OR /* Added for bug 13714500 */
2681: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
2682: where pll.po_header_id = pod.po_header_id
2683: and pll.po_line_id = pod.po_line_id)
2684: )
2685: )

Line 2754: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

2750: AND si.inventory_item_id = pol.item_id
2751: AND si.comms_nl_trackable_flag = 'Y'
2752: AND (si.organization_id = pod.org_id
2753: OR /* Added for bug 13714500 */
2754: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
2755: where pll.po_header_id = pod.po_header_id
2756: and pll.po_line_id = pod.po_line_id)
2757: )
2758: )

Line 2773: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

2769: and si.inventory_item_id = pol.item_id
2770: AND si.comms_nl_trackable_flag = 'Y'
2771: AND (si.organization_id = pod.org_id
2772: OR /* Added for bug 13714500 */
2773: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
2774: where pll.po_header_id = pod.po_header_id
2775: and pll.po_line_id = pod.po_line_id)
2776: )
2777: )

Line 2837: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

2833: AND si.inventory_item_id = pol.item_id
2834: AND si.comms_nl_trackable_flag = 'Y'
2835: AND (si.organization_id = pod.org_id
2836: OR /* Added for bug 13714500 */
2837: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
2838: where pll.po_header_id = pod.po_header_id
2839: and pll.po_line_id = pod.po_line_id)
2840: )
2841: )

Line 2856: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

2852: and si.inventory_item_id = pol.item_id
2853: AND si.comms_nl_trackable_flag = 'Y'
2854: AND (si.organization_id = pod.org_id
2855: OR /* Added for bug 13714500 */
2856: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
2857: where pll.po_header_id = pod.po_header_id
2858: and pll.po_line_id = pod.po_line_id)
2859: )
2860: )

Line 2922: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

2918: AND si.inventory_item_id = pol.item_id
2919: AND si.comms_nl_trackable_flag = 'Y'
2920: AND (si.organization_id = pod.org_id
2921: OR /* Added for bug 13714500 */
2922: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
2923: where pll.po_header_id = pod.po_header_id
2924: and pll.po_line_id = pod.po_line_id)
2925: )
2926: )

Line 2941: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

2937: and si.inventory_item_id = pol.item_id
2938: AND si.comms_nl_trackable_flag = 'Y'
2939: AND (si.organization_id = pod.org_id
2940: OR /* Added for bug 13714500 */
2941: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
2942: where pll.po_header_id = pod.po_header_id
2943: and pll.po_line_id = pod.po_line_id)
2944: )
2945: )

Line 3003: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

2999: AND si.inventory_item_id = pol.item_id
3000: AND si.comms_nl_trackable_flag = 'Y'
3001: AND (si.organization_id = pod.org_id
3002: OR /* Added for bug 13714500 */
3003: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3004: where pll.po_header_id = pod.po_header_id
3005: and pll.po_line_id = pod.po_line_id)
3006: )
3007: )

Line 3022: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3018: and si.inventory_item_id = pol.item_id
3019: AND si.comms_nl_trackable_flag = 'Y'
3020: AND (si.organization_id = pod.org_id
3021: OR /* Added for bug 13714500 */
3022: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3023: where pll.po_header_id = pod.po_header_id
3024: and pll.po_line_id = pod.po_line_id)
3025: )
3026: )

Line 3106: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3102: AND si.inventory_item_id = pol.item_id
3103: AND si.comms_nl_trackable_flag = 'Y'
3104: AND (si.organization_id = pod.org_id
3105: OR /* Added for bug 13714500 */
3106: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3107: where pll.po_header_id = pod.po_header_id
3108: and pll.po_line_id = pod.po_line_id)
3109: )
3110: )

Line 3125: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3121: and si.inventory_item_id = pol.item_id
3122: AND si.comms_nl_trackable_flag = 'Y'
3123: AND (si.organization_id = pod.org_id
3124: OR /* Added for bug 13714500 */
3125: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3126: where pll.po_header_id = pod.po_header_id
3127: and pll.po_line_id = pod.po_line_id)
3128: )
3129: )

Line 3197: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3193: AND si.inventory_item_id = pol.item_id
3194: AND si.comms_nl_trackable_flag = 'Y'
3195: AND (si.organization_id = pod.org_id
3196: OR /* Added for bug 13714500 */
3197: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3198: where pll.po_header_id = pod.po_header_id
3199: and pll.po_line_id = pod.po_line_id)
3200: )
3201: )

Line 3216: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3212: and si.inventory_item_id = pol.item_id
3213: AND si.comms_nl_trackable_flag = 'Y'
3214: AND (si.organization_id = pod.org_id
3215: OR /* Added for bug 13714500 */
3216: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3217: where pll.po_header_id = pod.po_header_id
3218: and pll.po_line_id = pod.po_line_id)
3219: )
3220: )

Line 3278: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3274: AND si.inventory_item_id = pol.item_id
3275: AND si.comms_nl_trackable_flag = 'Y'
3276: AND (si.organization_id = pod.org_id
3277: OR /* Added for bug 13714500 */
3278: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3279: where pll.po_header_id = pod.po_header_id
3280: and pll.po_line_id = pod.po_line_id)
3281: )
3282: )

Line 3297: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3293: and si.inventory_item_id = pol.item_id
3294: AND si.comms_nl_trackable_flag = 'Y'
3295: AND (si.organization_id = pod.org_id
3296: OR /* Added for bug 13714500 */
3297: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3298: where pll.po_header_id = pod.po_header_id
3299: and pll.po_line_id = pod.po_line_id)
3300: )
3301: )

Line 3365: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3361: AND si.inventory_item_id = pol.item_id
3362: AND si.comms_nl_trackable_flag = 'Y'
3363: AND (si.organization_id = pod.org_id
3364: OR /* Added for bug 13714500 */
3365: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3366: where pll.po_header_id = pod.po_header_id
3367: and pll.po_line_id = pod.po_line_id)
3368: )
3369: )

Line 3385: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3381: and si.inventory_item_id = pol.item_id
3382: AND si.comms_nl_trackable_flag = 'Y'
3383: AND (si.organization_id = pod.org_id
3384: OR /* Added for bug 13714500 */
3385: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3386: where pll.po_header_id = pod.po_header_id
3387: and pll.po_line_id = pod.po_line_id)
3388: )
3389: )

Line 3446: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3442: AND si.inventory_item_id = pol.item_id
3443: AND si.comms_nl_trackable_flag = 'Y'
3444: AND (si.organization_id = pod.org_id
3445: OR /* Added for bug 13714500 */
3446: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3447: where pll.po_header_id = pod.po_header_id
3448: and pll.po_line_id = pod.po_line_id)
3449: )
3450: )

Line 3465: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

3461: and si.inventory_item_id = pol.item_id
3462: AND si.comms_nl_trackable_flag = 'Y'
3463: AND (si.organization_id = pod.org_id
3464: OR /* Added for bug 13714500 */
3465: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
3466: where pll.po_header_id = pod.po_header_id
3467: and pll.po_line_id = pod.po_line_id)
3468: )
3469: )

Line 8992: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

8988: AND po_dist1.project_id IS NOT NULL
8989: AND si.comms_nl_trackable_flag = 'Y'
8990: AND (si.organization_id = po_dist1.org_id
8991: OR /* Added for bug 13714500 */
8992: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
8993: where pll.po_header_id = po_dist1.po_header_id
8994: and pll.po_line_id = po_dist1.po_line_id)
8995: ))
8996: )

Line 9213: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll

9209: AND po_dist1.project_id IS NOT NULL
9210: AND si.comms_nl_trackable_flag = 'Y'
9211: AND (si.organization_id = po_dist1.org_id
9212: OR /* Added for bug 13714500 */
9213: si.organization_id in (select nvl(ship_to_organization_id,-9999) from po_line_locations_all pll
9214: where pll.po_header_id = po_dist1.po_header_id
9215: and pll.po_line_id = po_dist1.po_line_id)
9216: ))
9217: )