DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 978: , PO_SYSTEM_PARAMETERS_ALL PARAMS

974: l_header_id_tbl
975: , l_segment1_tbl
976: FROM
977: PO_SESSION_GT SES
978: , PO_SYSTEM_PARAMETERS_ALL PARAMS
979: WHERE
980: SES.key = l_data_key
981: AND SES.num2 = PARAMS.org_id
982: AND PARAMS.manual_po_num_type = c_NUMERIC

Line 1099: PO_SYSTEM_PARAMETERS_ALL PARAMS

1095: , p_org_id_tbl(i)
1096: , p_segment1_tbl(i)
1097: , p_type_lookup_code_tbl(i)
1098: FROM
1099: PO_SYSTEM_PARAMETERS_ALL PARAMS
1100: WHERE
1101: PARAMS.org_id = p_org_id_tbl(i)
1102: AND PARAMS.user_defined_po_num_code = c_MANUAL
1103: AND p_segment1_tbl(i) IS NOT NULL

Line 1677: PO_SYSTEM_PARAMETERS_ALL

1673: , p_header_id_tbl(i)
1674: , PO_MESSAGE_S.PO_ALL_NOT_NULL
1675: , c_SEGMENT1
1676: FROM
1677: PO_SYSTEM_PARAMETERS_ALL
1678: WHERE
1679: org_id = p_org_id_tbl(i)
1680: AND USER_DEFINED_PO_NUM_CODE = c_MANUAL
1681: AND p_segment1_tbl(i) IS NULL;