DBA Data[Home] [Help]

APPS.JAI_GENERAL_PKG dependencies on QP_LIST_HEADERS

Line 768: qp_list_headers_b qlhb /* Added for bug#16288090 */

764: qlhb.currency_code /* Added for bug#16288090 */
765: FROM
766: qp_list_lines b,
767: qp_pricing_attributes c,
768: qp_list_headers_b qlhb /* Added for bug#16288090 */
769: WHERE
770: c.list_line_id = b.list_line_id AND
771: c.product_attr_value = decode(c.product_attr_value,'ALL',
772: c.product_attr_value,to_char(p_inventory_item_id)) AND--Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 778: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

774: qlhb.list_header_id = b.list_header_id AND /* Added for bug#16288090 */
775: p_ordered_date BETWEEN nvl( b.start_date_active, p_ordered_date)
776: AND nvl( b.end_date_active, SYSDATE) AND
777: EXISTS ( Select 1
778: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
779: where qlh.list_header_id = b.list_header_id
780: and a.customer_id = p_party_id
781: AND a.address_id = p_address_id
782: AND a.vat_price_list_id = b.LIST_header_ID

Line 802: qp_list_headers_b qlhb /* Added for bug#16288090 */

798: qlhb.currency_code /* Added for bug#16288090 */
799: FROM
800: qp_list_lines b,
801: qp_pricing_attributes c,
802: qp_list_headers_b qlhb /* Added for bug#16288090 */
803: WHERE
804: c.list_line_id = b.list_line_id AND
805: c.product_attr_value = decode(c.product_attr_value,'ALL',
806: c.product_attr_value,to_char(p_inventory_item_id)) AND--Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 811: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

807: trunc(nvl(b.end_date_active,sysdate)) >= trunc(p_ordered_date) AND
808: qlhb.list_header_id = b.list_header_id AND /* Added for bug#16288090 */
809: nvl(qlhb.active_flag,'N') = 'Y' AND /*added for bug#16288090*/
810: exists ( select 1
811: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
812: where a.customer_id = p_party_id AND
813: a.address_id = p_address_id AND
814: qlh.list_header_id = b.list_header_id AND
815: a.vat_price_list_id = b.list_header_id AND

Line 835: qp_list_headers_b qlhb /* Added for bug#16288090 */

831: qlhb.currency_code /* Added for bug#16288090 */
832: FROM
833: qp_list_lines b,
834: qp_pricing_attributes c,
835: qp_list_headers_b qlhb /* Added for bug#16288090 */
836: WHERE
837: c.list_line_id = b.list_line_id AND
838: c.PRODUCT_ATTR_VALUE = decode(c.product_attr_value,'ALL',
839: c.product_attr_value,TO_CHAR(p_inventory_item_id)) AND--Modified by Junjian on 15-Oct-2012 for bug#14736812

Line 845: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a

841: NVL(qlhb.end_date_active,SYSDATE) >= p_ordered_date AND
842: NVL(qlhb.active_flag,'N') = 'Y' AND /*Added for bug#16288090*/
843: NVL(b.end_date_active,SYSDATE) >= p_ordered_date AND
844: EXISTS ( select 1
845: from qp_list_headers qlh, JAI_CMN_CUS_ADDRESSES a
846: WHERE a.customer_id = p_party_id AND
847: a.address_id = p_address_id AND
848: qlh.list_header_id = b.list_header_id AND
849: a.vat_price_list_id = b.LIST_header_ID AND

Line 877: qp_list_headers_b qlhb /* Added for bug#16288090 */

873: FROM
874: JAI_CMN_VENDOR_SITES a,
875: qp_list_lines b,
876: qp_pricing_attributes c,
877: qp_list_headers_b qlhb /* Added for bug#16288090 */
878: WHERE
879: a.vendor_id = p_vendor_id AND
880: a.vendor_site_id = p_address_id AND
881: a.vat_price_list_id = b.LIST_header_ID AND

Line 912: qp_list_headers_b qlhb /* Added for bug#16288090 */

908: FROM
909: JAI_CMN_VENDOR_SITES a,
910: qp_list_lines b,
911: qp_pricing_attributes c,
912: qp_list_headers_b qlhb /* Added for bug#16288090 */
913: WHERE
914: a.vendor_id = p_vendor_id AND
915: a.vendor_site_id = p_address_id AND
916: a.vat_price_list_id = b.list_header_id AND

Line 942: qp_list_headers_b qlhb /* Added for bug#16288090 */

938: FROM
939: JAI_CMN_VENDOR_SITES a,
940: qp_list_lines b,
941: qp_pricing_attributes c,
942: qp_list_headers_b qlhb /* Added for bug#16288090 */
943: WHERE
944: a.vendor_id = p_vendor_id AND
945: a.vendor_site_id = p_address_id AND
946: a.vat_price_list_id = b.LIST_header_ID AND

Line 1003: qp_list_headers_b qlhb /* Added for bug#16288090 */

999: FROM
1000: jai_cmn_cus_addresses a
1001: , qp_list_lines b
1002: , qp_pricing_attributes c,
1003: qp_list_headers_b qlhb /* Added for bug#16288090 */
1004: WHERE a.customer_id = pn_party_id
1005: AND a.address_id = pn_address_id
1006: AND a.vat_price_list_id = b.list_header_id
1007: AND c.list_line_id = b.list_line_id

Line 1040: qp_list_headers_b qlhb /* Added for bug#16288090 */

1036: FROM
1037: jai_cmn_cus_addresses a
1038: , qp_list_lines b
1039: , qp_pricing_attributes c,
1040: qp_list_headers_b qlhb /* Added for bug#16288090 */
1041: WHERE a.customer_id = pn_party_id
1042: AND a.address_id = pn_address_id
1043: AND a.vat_price_list_id = b.list_header_id
1044: AND c.list_line_id = b.list_line_id

Line 1076: qp_list_headers_b qlhb /* Added for bug#16288090 */

1072: FROM
1073: jai_cmn_cus_addresses a
1074: , qp_list_lines b
1075: , qp_pricing_attributes c,
1076: qp_list_headers_b qlhb /* Added for bug#16288090 */
1077: WHERE a.customer_id = pn_party_id
1078: AND a.address_id = pn_address_id
1079: AND a.vat_price_list_id = b.list_header_id
1080: AND c.list_line_id = b.list_line_id

Line 1113: qp_list_headers_b qlhb /* Added for bug#16288090 */

1109: FROM
1110: jai_cmn_vendor_sites a
1111: , qp_list_lines b
1112: , qp_pricing_attributes c,
1113: qp_list_headers_b qlhb /* Added for bug#16288090 */
1114: WHERE a.vendor_id = pn_vendor_id
1115: AND a.vendor_site_id = pn_address_id
1116: AND a.vat_price_list_id = b.list_header_id
1117: AND c.list_line_id = b.list_line_id

Line 1150: qp_list_headers_b qlhb /* Added for bug#16288090 */

1146: FROM
1147: jai_cmn_vendor_sites a
1148: , qp_list_lines b
1149: , qp_pricing_attributes c,
1150: qp_list_headers_b qlhb /* Added for bug#16288090 */
1151: WHERE a.vendor_id = pn_vendor_id
1152: AND a.vendor_site_id = pn_address_id
1153: AND a.vat_price_list_id = b.list_header_id
1154: AND c.list_line_id = b.list_line_id

Line 1186: qp_list_headers_b qlhb /* Added for bug#16288090 */

1182: FROM
1183: jai_cmn_vendor_sites a
1184: , qp_list_lines b
1185: , qp_pricing_attributes c,
1186: qp_list_headers_b qlhb /* Added for bug#16288090 */
1187: WHERE a.vendor_id = pn_vendor_id
1188: AND a.vendor_site_id = pn_address_id
1189: AND a.vat_price_list_id = b.list_header_id
1190: AND c.list_line_id = b.list_line_id